Transpose data in data script

[Amelia_96]

Hi, i'm trying to transpose data but making it distinct by ID. Is there anyone who knows how to do this in qlikview script?

Here is the sample data:

Here is the expected output:

Please help. Thank you in advance!!

[MayilVahanan]

Hi @Amelia_96 

Try like below. 

T1:
Load * Inline
[
ID, Category
a1, small
a1, medium
a1, large
a2, small
a3, medium
a3, large
a4, small
a5, small
a5, medium
a5, large
a5, extra large
];

Load ID, SubField(Cat, '|', 1) as C1, SubField(Cat, '|', 2) as C2, SubField(Cat, '|', 3) as C3, SubField(Cat, '|', 4) as C4;
LOAD ID, Concat(Category, '|', Category) as Cat Resident T1
group by ID;

Drop table T1;

[Amelia_96]

Thank you so much. This helps a lot.