In case you are engaged on a worksheet with knowledge in columns and need to rotate it and rearrange these knowledge into rows, the Transpose function in Microsoft Excel is available in actually helpful. The software permits customers to simply change knowledge from rows to columns or vice versa. Right here’s easy methods to do it.
Pre-requisites:
Microsoft Excel
A worksheet with knowledge in rows and columns
1.
Open a worksheet with knowledge in Excel
Open a worksheet with knowledge in Excel
2.
Choose the vary of information together with the labels and replica it by urgent Ctrl+C or Cmd+C (on Mac)
Choose the vary of information together with the labels and replica it by urgent Ctrl+C or Cmd+C (on Mac)
3.
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.
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.
4.
Proper-click on the top-left cell the place you need to paste the information and select the choice Transpose
Proper-click on the top-left cell the place you need to paste the information and select the choice Transpose
5.
As soon as pasted, you possibly can choose the earlier desk and delete it.
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.
Additionally learn:
How to use PivotTable in Microsoft Excel