Once you have selected the cells in the column, right-click on the
destination cell and select Paste Special, then click the checkbox Transpose.
Columns will be transformed in rows and vice versa.
You can select each cell value by pressing the Crtl key. But you cannot copy
the cell values. The following message will display:
"That command cannot be used on Multiple selections"
Note: You have manually rearrange the cells in a row or columns and then do
the following:
1. Select the all the cell values, right-click and then select Copy.
2. Click and select a new cell location.
3. On the Edit menu, click Paste Special. The Paste Special dialog box is
displayed.
4. Select the Transpose check box.
5. Click Ok. This will display all rows in cloumn.
Scenario 2:
If the cells values are adjacent to each column then you can do the following:
1. Select the all the cell values, right-click and then select Copy.
2. Click and select a new cell location.
3. On the Edit menu, click Paste Special. The Paste Special dialog box is
displayed.
4. Select the Transpose check box.
5. Click Ok. This will display all rows in cloumn.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
