For instance, some people construct spreadsheets in Excel with the primary fields arranged in a horizontal fashion. Different people will look at the data in different ways.

The columnar data may be a mess, with various properties scattered across several columns. It is preferred, in general, for each row of data to be analogous to a record and to contain a single data point. True or false: The TRANSPOSE function can be used to turn columns into rows, or rows into columns.You may be curious how it is going to help if we take data that is organised in many columns and turn it into rows. Which of these formulas will switch columns and rows?

Which of these formulas will turn a column into a row? Which of the following formulas will turn a row into a column? I hope that this lesson on the TRANSPOSE function makes your work faster and easier!Īnswer the questions below about the TRANSPOSE formula, to refine your knowledge! Scroll to the very bottom to find the answers to the quiz. The formula: The formula below, is entered in the blue cell (A1), for this exampleĪs you can see in the image above, the data from the tab 'Sheet 1' has been transposed into a completely different tab. 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. 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.

Convert columns to rows in excel