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.

Shares

UP NEXT: How to Import Contacts from your Desktop

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz