How to copy values available in different cells of a column into d

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to copy values (or data) available in different cells of a column into
different cells of a row?
 
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.
 
Copy
Edit/ Paste Special/ Transpose

or =OFFSET([absolute ref of first cell of source
column],COLUMN()-COLUMN([absolute ref of first cell of destination row]),0)
 
Hi,

There are two scenarios illustrated below:

Scenario 1:

If the cell are in different location in columns.

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.

Challa Prabhu
 
Back
Top