How to make column data as headers in straight table

[#1]

I am importing the data from smartsheet, and for one of the column information i need to make headers

For Eg:

Project Name     TG1     TG2     TG3

A                         10          20     30

B                         30          40     60

Attaching the qvw file, did someone come across similar scenario?

[vishsaggi · Accepted solution]

Is this what you are looking for?

Check attached. Using Pivot table you can shift the columns to headers.

[#3]

Yes this is what i wanted, but how did you drag that field after creating pivot? could you please elaborate it a bit?

[vishsaggi]

Once you add dimensions in pivot chart. Just select the dimension you want to drag, hold the mouse key and move the field like below. Click on TG and then holding the key on mouse you can move to top or left, based on the movement the blue arrow changes its direction. Hope this helps.

[#5]

Hey Thank you very much it worked, i actually have to drag all the way to the end, then the horizontal line appears.