How to convert a column of data in excel into a row of excel data column method

Sometimes we need to convert a column of data in an Excel table into a row, for example, we copy a column of data, want to be in a new The table needs to be placed horizontally, we can't input them one by one, but excel provides such a function. Let's see what to do.

Steps

First, we open a table with a list of names, and we want to traverse this column of data.

Drag the mouse to select this column of data by dragging the mouse from cell A1 to know the last name.

We click on Edit on the menu bar and in the Edit menu we select Copy.

Just find an empty cell. This cell is the first cell of a row of data we will create in the future. You may not understand it here. You can continue to look down.

Then click Edit on the menu bar and click “Select Paste in the Edit menu to remember to paste selectively instead of pasting.

A dialog box for selective pasting pops up. We check the bottom of the "transpose”, then click the OK button.

7 This pastes a row of data behind the C1 cell. This row of data is exactly what this column of data is converted from.