Converting CSV data held in table cell into seperate rows

[#1]

I've imported a SharePoint List into a QlikView report but some of the data has been returned as CSV (semi-colon separated) in table cells, shown in the first table.

I would like to split this in to separate rows, shown in the second table.

Can this be done?

Group	Approver
L1	User1; User2; User3
L2	User2; User4; User5
L3	User1; User5
L4	User6
L5	User7

Group	Approver
L1	User1
L1	User2
L1	User3
L2	User2
L2	User4
L2	User5
L3	User1
L3	User5
L4	User6
L5	User7

Thanks for your help.

[Anil_Babu_Samineni · Accepted solution]

Do this?

Load Group, SubField(Approver,';') as Approver;

LOAD Group,

     Approver

FROM

[https://community.qlik.com/message/1262900]

(html, codepage is 1252, embedded labels, table is @1);

[#3]

That worked

Thanks Anil