A worksheet with knowledge in rows and columns
Open a worksheet with knowledge in Excel
Choose the vary of information together with the labels and replica it by urgent Ctrl+C or Cmd+C (on Mac)
Choose a brand new location inside the worksheet the place you need to paste the transposed knowledge. Additionally, guarantee that there’s loads of area to stick all the information from the chosen desk.
Proper-click on the top-left cell the place you need to paste the information and select the choice Transpose
As soon as pasted, you possibly can choose the earlier desk and delete it.
Further ideas to remember whereas transposing your knowledge
In case your worksheet comprises formulation, Excel routinely makes the mandatory adjustments as per the brand new placement.
Additionally, in case you usually use transpose to view it from totally different angles, making a PivotTable as it will probably assist because it lets you shortly pivot your knowledge by dragging fields from Rows to columns and vice versa.
How to use PivotTable in Microsoft Excel