Skip to content

How to Transpose Data in Google Spreadsheets

< 1 minute read

Sheets Green

One of the main issues you may hear about Google Apps is that Spreadsheets don’t have the same functionality as traditional applications. Well we happen to think very highly of Spreadsheets (shocking, right?), and this video will demonstrate how to perform the popular Transpose function that many former Excel users have trouble finding.

1.) In the cell where you would like to transfer your data to, type the function =TRANSPOSE(

2.) Select the range of cells you wish to copy by dragging your cursor across all cells.

3.) Close the function with so it will look like this =TRANSPOSE(A1:F5)

4.) Hit enter on your keyboard and you’re done!

Click here to watch this video on YouTube.

Sign up for our newsletter