How to copy column data to row in excel?

Asked By:
3 answer(s)
Answer # 1 #

The column data will now appear in a row format.

[2 Month]
Answer # 2 #
  1. Select the column data. 2. Copy it (Ctrl+C). 3. Right-click on the destination cell. 4. Choose 'Paste Special' → 'Transpose'.
[2 Month]
Answer # 3 #

To transpose column data to a row in Excel:

[3 Month]