Forum Discussion

Copper Contributor

Mar 10, 2026

Solved

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?

Olufemi7
Mar 10, 2026
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

Iron Contributor

Mar 10, 2026

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

Kamni01
Copper Contributor
Mar 11, 2026
Thank you this was helpful!