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


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 new list items for inclusion

Comments 0

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

Solve : Which Number is Larger 4 or 8 ?

You are invited to the talkKs Reader Community

Join Now