Forum Discussion
Convert rows into columns
Is there a way when inputting a table from word into an excel spreadsheet to have the set information from rows into colums?
1 Reply
HelloKamni01,
Yes. You can convert rows to columns after pasting a table from Microsoft Word into Microsoft Excel by using Transpose.
- Paste the table into Excel.
- Copy the pasted range.
- Right click in an empty cell.
- Select Paste Special.
- Choose Transpose and click OK.
This will switch rows into columns and columns into rows.
You can also use the TRANSPOSE function if you want the result to stay linked to the original data.
=TRANSPOSE(A1:D5)
Microsoft documentation
https://support.microsoft.com/office/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027
