Here we’re going to look at how we can use the TRANSPOSE function to change our data from being vertical to being horizontal, or vice versa.
Changing a single column or row of data
Here we have the days of the week in a column and we want to put them horizontally, so that each day is in a different column across the page.
In cell C1, I write the following function:
As you can see, it changes the information from being vertically stacked to being horizontally laid out.
This works both ways. If the original data was horizontally laid out, then in cell A1, we could write this function:
This would display the days vertically.
Converting 2 vertical columns to 2 horizontal ones
Here we have the days of the week and some teachers. I want to lay both sets of information horizontally.
This is easy, just include both columns in the range in the TRANSPOSE function.
This will then take column A and put it in row 1, then take column B and put it in row 2.
Converting multiple horizontal rows into vertical columns
Similar to the previous example, we can do the same for more than 2 sets of data.
Include the complete range in the TRANSPOSE function.
And sure enough, it transposes the information from rows to columns.
The above is using the TRANSPOSE function, to do it automatically for you, but remember you can also copy your data and using paste transpose, you can transpose it manually. Just right click, select Paste special, then Paste transpose. See my post on moving and pasting data for more examples.
eBooks available on Drive, Forms, Sheets, Docs, Slides, and Sheet Functions:
- “Beginner’s Guide to Google Drive” – iBooks store / Kindle store
- “Beginner’s Guide to Google Forms” – iBooks store / Kindle store
- “Beginner’s Guide to Google Sheets” – iBooks store / Kindle store
- “Beginner’s Guide to Google Docs” – iBooks Store / Kindle store
- “Beginner’s Guide to Google Slides” – iBooks Store / Kindle store
- “Google Sheet Functions – A step-by-step guide” – iBooks Store / Kindle Store