I have a large excel data set, sample below:
- Name City1 City2
- User1 NYC LAX
- User2 LAX CHI
- User3 SFO NYC
- User4 CHI SFO
I would like to create pivot tables (1 table/unique city) such that the Name is picked up from either City1 or City2, as below:
Please guide on how I can achieve this? Thanks.