multiple column as single data field

[userid128223]

I have crosstable format data like below.

john;trin;bayley;bruce;arthur;colin

How can i load it in qlikview as data and called the field header usernames

UserNames

John

Trin

bayley

bruce

arthur

colin

[tajmohamed30]

go to enable transform step, navigate tab and select transpose

[tajmohamed30]

before doing this you can add a column name before first name

[Sergey_Shuklin]

Hello!

This will help:

LOAD SubField(x,';') as UserNames Inline

[x

john;trin;bayley;bruce;arthur;colin]