Data - Transpose - Block

Ribbon bar. Select the Data tab. In the Transformations group, click Transpose and from the menu, select Transpose Block...

Classic menus. From the Data - Transpose submenu, select Block...

...to transpose a square block of selected data in the spreadsheet. This command only transposes the data values defined by the selected (highlighted) data and not the entire data file (see Transpose File).