How to copy column data to row in excel?

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

The column data will now appear in a row format.

[4 Month]
Answer # 3 #

To transpose column data to a row in Excel:

[4 Month]