Transposing Data in Excel

What do you do if you have data in a column in Microsoft Excel but really want it to be in a row? You may want to transpose your data, or transform it from a column into a row or vice versa, for a variety of reasons. Whatever your reason, here is a quick and easy way to transpose your data.

Instructions

Step 1 Highlight your data

Highlight your range of data, whether it is in a column or in a row. You can do this by clicking on the cell in one corner of your data range, then click the cell on the opposite corner while holding down the shift key. Alternatively, when in one corner, hold down the shift and control keys simultaneously while using the arrow keys to highlight the range.

Step 2 Copy the data

Copy your data range. The quickest way to do this is to use the keyboard shortcut, Control + C.

Step 3 Open the Paste Special menu

Go to the cell in the top left corner where you would like your new transposed data to be placed. On the Home Tab, select the PASTE DROP-DOWN BOX in Microsoft Excel, then select Paste Special.

Step 4 Transpose your data

In the Paste Special menu, select "Transpose" at the bottom of the menu, then click "OK." Your data range will now be transposed.