How did I create the Pivot Table...I can't remember...the field list shows Rows, Columns, Value instead of showing the column names (fields)
Pivot Table field list.png
How did I create the Pivot Table...I can't remember...the field list shows Rows, Columns, Value instead of showing the column names (fields)
Pivot Table field list.png
Weird. Could you post a sanitized version of the workbook?
Pete
I suspect you created it using consolidation ranges.
Rory
To see exactly how this is done. You can read below link.
See section titled " Reverse Pivot Table With PivotTable And PivotChart Wizard"
https://www.extendoffice.com/documen...vot-table.html
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
I had a suspicion it was an extendoffice product.
Pete
Nah, it's not the product. Scroll down a bit, you should find process to do it using Pivot Table Wizard.
Before introduction of PowerQuery/Get & Transform. Pivot Table wizard was the standard method to transpose data table, without use of VBA.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks