Home » Google » Apps » Sheets » Google Spreadsheets: Transpose in 2 easy steps

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.

Notice the list of names now goes across the cells.

6 thoughts on “Google Spreadsheets: Transpose in 2 easy steps”

  1. Pingback: 07: 2015-03-03 CI100 | CSUF CI 100 Keeler

  2. Pingback: 07: 2014-03-03 CI225 | CSUF CI225

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.