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 is to switch from horizontal to vertical or vice versa. In other words from rows to columns (or columns to rows.).
Right click in a blank cell. Choose paste special and paste transpose.