transpose certain rows to columns

[jennytan]

Hi,

Can somebody help me on this?

I have names, address, contact information and deivery info captured as description in the invoice lines and I have extracted using qlikview which will give me the following format:-

I want to be able to convert the various lines belonging to the same invoice no as a column each so that I can extract the relevant name, address, contact, delivery criteria, etc like this:-

Is it possible to do using Qlikview?

Thanks

[avinashelite · Accepted solution]

Try  with Generic reload 

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470