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

"Satish" wrote:

How to copy values (or data) available in different cells of a column into
different cells of a row?