MS Excel: Transpose: flip rows into columns

I needed to transpose data from rows to columns from an Excel worksheet so that I could bring it into Airtable – I was dreading doing it manually until I found out about MS Excel’s transpose feature – works like a charm!

Troubleshooting:

• https://superuser.com/questions/562065/why-is-the-transpose-check-box-in-the-paste-special-dialog-greyed-out