AskSawal
Question & Answer Forum
🔍
0
Ask Question
Write Answer
Technology
How to copy column data to row in excel?
+ Add Answer
3
answer(s)
Excel
Data Manipulation
Spreadsheet
Answer # 1 #
Select the column data. 2. Copy it (Ctrl+C). 3. Right-click on the destination cell. 4. Choose 'Paste Special' → 'Transpose'.
Answered by:
Ybuitiot Al
[4 Month]
(
5
)
Comment
Report
Answer # 2 #
The column data will now appear in a row format.
Answered by:
Hymjddeieb Snljya
[4 Month]
(
4
)
Comment
Report
Answer # 3 #
To transpose column data to a row in Excel:
Answered by:
Hymjddeieb Snljya
[4 Month]
(
4
)
Comment
Report
Related Questions
How to fill same data in excel columns?
How to freeze certain rows and columns in excel?
How to freeze only selected rows and columns in excel?
How to freeze first row and column in excel?
What is column and row in excel?
How to freeze any row or column in excel?
How to freeze any row and column in excel?
How to freeze one column and one row in excel?
How to get row and column number in excel?
How to remove row and column highlight in excel?