Copy and transpose data in Microsoft Excel

Copy and transpose data

Select certain cell(s) you want to transpose.
Click Copy button.
Select destination cell.
Click Edit, Paste Special, Transpose, OK.
Press Esc on your keyboard to end.

Leave a Reply