Forum Discussion
jthomsoun
Feb 23, 2023Copper Contributor
How to have column values arranged in pivot as in the picture?
Hello, In pivot, I basically want to arrange 2 values - Agent & Ticket ID. The current view is like this, I want to view as like this, The pivot is...
Lorenzo
Feb 24, 2023Silver Contributor
As non Mac user I missed the recent General Availability of the Power Query Editor for Excel Mac
The cheaty option:
- Load the Source Table to Power Query
- Group the table by Agent
- Sort each group Ticket IDs
- Add an Index to each Group
- Expand all fields
- Close & Load To... > PivotTable Report
In the PivotTable:
- Agent Index to Rows
- Agent to Columns
- Ticket ID to Values
Then Hide the column that holds the Agent Index:
In the attached file 2 Power Queries that keep or remove duplicates
All query steps done with the User Interface (shorter version exists with the Advanced Editor)