The logic: Transpose the range A1:I9, from 'Sheet 1' The task: Transpose the data from 'Sheet 1', into another tab Second, if the tab that you are referring to has a space in its name, you must also include an apostrophe before and after the tab name (as shown below). But remember two important things when referring to other tabs in your formulas.įirst, make sure that you put an exclamation point after the tab name, to indicate to Google Sheets that you are referencing a tab. You don't have to worry about the name of the tab with the formula, because it is the tab with the course data that we need to refer to with our formula.Īs shown below, you can simply add the tab name before typing the cell range, to refer to data from another tab.

Let's say that we want to refer to the same source data (student grades) from the previous example, but we want to put our formula on a completely different tab.įor this example, let's say that our raw / source data is on a tab named 'Sheet 1'. This can be done by adding a tab name to your formula. You might also find the need to transpose data that is on another sheet / tab. 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.You can see that starting at row 11, the student grade data has been transposed, so that the columns were turned into rows, and vice versa the rows were turned into columns. 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 excel columns to rows