The feature works with all recent versions of Microsoft Excel, including Office 365. I hope the post was easy to follow and you can now transpose rows into columns.

You can use Excel's paste special option to experiment with a different data arrangement by flipping your spreadsheet cells. The command arranges the row data as columns and vice versa.