0
The source data has the headers in column A and the data in the rest of the columns. Is there anyway to have excel recognize this and make a pivot table?
0
The source data has the headers in column A and the data in the rest of the columns. Is there anyway to have excel recognize this and make a pivot table?
0
No. It will not recognize it in that format. You must transpose the data for the pivot table to work properly.
Transpose
(depending on your
version it may be in the context menu or in paste special
).
1
Follow this to swap columns with rows https://www.timeatlas.com/switch-excel-columns-rows/
– mt025 – 2016-08-10T18:37:52.280