Note:
Paste transposed data using the special paste options within the right-click menu.
Parents:
right click cell menu
paste formula menu
Where’s That Button?