Google Spreadsheets: Transpose in 2 easy steps

Today Google announced some new features for Google Sheets on their blog. Many of the new features are exciting, but one I am particularly excited about is “paste transpose.” One feature of Excel that I use a lot is to paste special and transpose cells, unfortunately this was not a feature in Google Sheets, until now.

Transpose

Transpose is to switch from horizontal to vertical or vice versa. In other words from rows to columns (or columns to rows.).

Step 1

Copy a list of either vertical or horizontal cells.

Step 2

Right click in a blank cell. Choose paste special and paste transpose.

My Referral Links

50% Off February Special

Online Workshops for Google Sheets, Classroom, Slides and more are 50% off for February. Use the discount code february at checkout. Also annual subscriptions for access to all of the Go Slow online workshops are 50% off!