Copy and Paste an Array with Rows and Columns Flipped (10/20)


A screen shot of a spreadsheet in google docs.
A screen shot of a spreadsheet in google docs.

0

If you want to copy an array to another location in Google Sheets but want it with rows and columns flipped, you can easily copy the cells you want and then right click on the first cell where you want to paste the array. Then you will get the right-click menu. From here, select Paste Special →  Transposed. Your array will be automatically pasted with rows and columns flipped.


talkKs editorial
Use the comment section to suggest things we might have missed.

Comments 0

Your email address will not be published. Required fields are marked *

Solve : Which Number is Smaller 5 or 6 ?