This is really easy, but something I never knew until I just tried this:

  1. Copy the cells you want to flip
  2. Right-Click “Paste Special”
  3. Tick the Transpose checkbox

You’re done! Best Excel trick ever!