Choose a location where you want to paste the transposed table. Using the Paste Special feature is a quick way to switch rows and columns in Excel. Switch Rows and Columns by Paste Special (Transpose) Read the following article in detail and choose the best solution that matches your intent.ġ. We will use this dataset to demonstrate how to switch rows and columns in Excel. Let’s say you have the following dataset of the Market share of the smartphone companies. Step 5: Go back to your Word document, press Ctrl+V to paste the transposed table.Īfter rotating the data successfully, you can delete the original data.5 Methods to Switch Rows and Columns in Excel Step 4: Press Ctrl+C to copy the transposed data in Excel. The rows become the columns and the columns become the rows. Right-click the first cell where you want to paste the data, and pick Transpose. Select the cells ranges you want to transpose, and then press Ctrl+C to select it. Step 3: Use transpose feature to rotate data in rows and columns. Open an Excel workbook, click in a blank cell on the worksheet, press Ctrl+V to paste it. Step 2: Paste table data to an Excel worksheet. In Microsoft Word, select all data in Word table, then press Ctrl+C on your keyboard to copy it. Step 1: Select and copy data in Word table. Steps to Convert Data from Rows to Columns in a Worksheet

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. Word does not have a built-in way to transpose a table. This is a guide on how to convert data from rows or columns in Word table. How to Convert Data from Rows to Columns in Word Table

Change row to column in excel