Excel ranks how to replace

Excel ranks how to replace

Let's first assume that there is such a tabular data.

Now select the row data and press CTRL + C to copy it. Next select the first cell you want to convert to a column, and then click the Paste button on the toolbar, clicking Paste Selective to open an option window, check the "transpose" item, and make sure. Finally, you can delete the extra data in the line.

In addition to row and column data exchange, there are times when data is exchanged between columns and columns. This is easier to achieve. Select the column that you want to swap, and then move the cursor over the right side of the column, and when the cursor becomes a cross arrow shape, hold down the SHIFT key and drag the column to the desired position, releasing the mouse button.