Apr 04 2018
09:35 AM
- last edited on
Jul 12 2019
11:06 AM
by
TechCommunityAP
Apr 04 2018
09:35 AM
- last edited on
Jul 12 2019
11:06 AM
by
TechCommunityAP
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 as it sits. I cannot get the fields now in the columns to display as in the rows. I want the date fields in the columns rather than the rows. If possible I would rather not change the source data as it sits; but would if it meant I had a solution.
Thank you for your consideration
Apr 04 2018 11:37 PM
Jul 23 2018 05:50 PM
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.