iSumsoft » Resources » Office » How to Select Cells Range, Rows or Columns in Excel

How to Convert Data from Rows to Columns in Word Table

This is a guide on how to convert data from rows or columns in Word table.

Word does not have a built-in way to transpose a table. However, with the help of transposing rows and columns feature in Excel, you can quick way to transpose data from rows to columns or vice versa.

Steps to Convert Data from Rows to Columns in a Worksheet

Step 1: Select and copy data in Word table.

In Microsoft Word, select all data in Word table, then press Ctrl+C on your keyboard to copy it.

Copy date in Word table

Step 2: Paste table data to an Excel worksheet.

Open an Excel workbook, click in a blank cell on the worksheet, press Ctrl+V to paste it.

Paste table to a worksheet

Step 3: Use transpose feature to rotate data in rows and columns.

Select the cells ranges you want to transpose, and then press Ctrl+C to select it. Right-click the first cell where you want to paste the data, and pick Transpose. The rows become the columns and the columns become the rows.

Transpose rows and columns

Step 4: Press Ctrl+C to copy the transposed data in Excel.

Copy transposed table

Step 5: Go back to your Word document, press Ctrl+V to paste the transposed table.

Paste transposed table to Word

After rotating the data successfully, you can delete the original data.