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:


  • User1
  • User3



  • User1
  • User2

Please guide on how I can achieve this? Thanks.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.