Forum Discussion
Problem changing rows to columns in a pivot table
I am a long time user of excel but new to pivot tables. I cannot get a pivot table to transpose the data from rows to columns. I have included an excel file with the source data and the pivot table...
Hi, I am in a similar situation. I cannot see the new column headings no matter what I do with Pivot Table.
Instead I copied all the data to my clipboard and on a new sheet I pasted it using the T for transpose option and Voila! columns become rows and vice versa just how I wanted it. Then some tidying up to suit col widths etc. Sorted.