Excel Transpose Data

Excel Transpose Data


Excel: Transpose Data
If you have data in columns and you wish that data were in rows (or if you have data in rows that you wish were in columns), you do not need to retype it.
Simply select the data and hit the Copy button.
Next, select the cell that you want to become the upper left corner of the new range of data.
Go to the menu bar and choose Edit Paste Special. In the Paste Special dialog box, choose Transpose.

or
=TRANSPOSE(A1:A3)


www.svdeals.com super value deals