Load rows as separate column in same file

[tejasp47]

Hello, 

I have specific requirement to achieve and I want some help to find optimal way. 

Attached image - 

I want the Country names from rows into separate columns and at the same time to map it to correct Product. 

Regards,

Tejas P

[dplr-rn]

i think you may need generic load
https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470