How can I convert columns into row in Excel?

Answer by  ardentblarney (32)

Try using the Paste Special command to transpose a column of data to a row of data and that should work vice versa also.

Answer by  senthilkumar (299)

select the cells that you want to convert,click copy,select the upper left cell of the paste area,the paste area must be out side of the copied area, click the arrow to the right of the paste and then click transpose your columns will be convert into rows.

Answer by  zombieguy (986)

Begin by highlighting all the information in the column that you would like to change into a row. Right click on it and select 'Cut' or 'Copy'. Next, right click on the first cell in the row you'd like to move it to and select 'Paste Special'. Select 'Transpose' from the popup dialog. This will turn it into a row.

Answer by  rina12 (12)

Select the columns. Copy the text in the selected columns. Right click the cell where you want to put the text then click PASTE SPECIAL. A dialog box will appear. You need to check the TRANSPOSE then click OK.

Answer by  severaltimes (247)

Copy your data and paste it by right-clicking and selecting Paste Special. Select "Transpose" and hit OK to paste your data. This only works in Excel 2000 or more recent, however.

Answer by  murali680 (559)

First of all you copy the column which you have to convert. Then right click the mouse and select the past special. In this option, first you select option named as 'all'. Then click transpose option. Now press ok, column get changed into row.

Answer by  Naimad (98)

If you have data in columns and you want to change that into row just select the data and copy then go to the row where you want the info and right click, select paste special and select transpose option and click OK that will change columns into rows

Answer by  Rani60 (351)

To transpose from a Column into a Row. To transpose the values in Column A (List1) into a Row: Using the INDEX and COLUMN functions, enter the following formula in cell C2, and then copy it across the next 3 cells in the row.

Answer by  belindagold (39)

Select the column you want to change, then Ctrl+C (that will copy the data and is evidenced by the "marching ants") then place your insertion point where you want the rows to start and select Edit, then Paste Special. choose transpose. This will past your column as a row

Answer by  murali680 (559)

To convert from columns to row, the followings are the procedure. First select the column which to be changed into row. Then copy this column. Then right click the mouse, click the paste special option from that option. A dialog box will open; in it you select the transpose. That's all.

Answer by  davidsmith4deltaedu (338)

One must, copy the data in the source column first. Then right click in the row, and click paste special. On the paste special dialog box choose, all, none, and transpose.