patrickgoh
New Member
- Joined
- Aug 24, 2018
- Messages
- 1
Hi all, I’m a basic user but a big fan of pivot tables. I’ve to rush out a report for several thousands of records but struggle to achieve the outcome with pivot. Hence, my SOS reach out to this community.
My table has more headers but let me simplify it to a table with 3 columns - Name, Origin and Destination. Both origin and destination take reference from same masterfile of country codes. Each data row is a lane of traffic - name (of person) flew from origin to destination.
I need to, say, find a way to pivot the activity associated with, say SYD as both an origin and destination.
How do I possible pivot a table to do this? At present, I have pivoted one by origin, and another pivot table by destination. Then manually combine the activity level of SYD as origin and destination.
My table has more headers but let me simplify it to a table with 3 columns - Name, Origin and Destination. Both origin and destination take reference from same masterfile of country codes. Each data row is a lane of traffic - name (of person) flew from origin to destination.
I need to, say, find a way to pivot the activity associated with, say SYD as both an origin and destination.
How do I possible pivot a table to do this? At present, I have pivoted one by origin, and another pivot table by destination. Then manually combine the activity level of SYD as origin and destination.