Transpose? Crosstable? Generic Load?

[haymarketpaul]

QV11 SR2

I'm trying to work out the best way to transpose the following data.  I've been looking at possibly using transpose, crosstable or generic load but i'm not quite which if any are the best to use.  Any advice much appreciated.

This is the format i am trying to achieve...

[#2]

If I've understood it correctly, you could create a pivot table and then just drag the Interest Area Dimension to the top of the table, and It will appear just the way you want.

Hope this helps.

[anandathome]

Can you load this full data into qlikview and then convert it using pivot chart in the way you want?

[haymarketpaul]

Yes that sounds like it would do the trick  - i can't seem to work out how to drag the column (Job Role) though?  I've attached my qvw if someone could take a quick look that would be great. 

[anandathome · Accepted solution]

Please find attached.

You have to drag the Interest Area

field and take it to the right and to the top of column name, it shows a blue line.

Drop it at the top of column name.

[haymarketpaul]

Ah Got it - Thank you Anand