Copy from one excel spreadsheet to another

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
I have 2 separate excel documents. 1 is formatted horizontally, first name last name phone email, etc. The 2nd document is formatted vertically, first name last name phone email, etc. How can I easily transfer the data from the 2nd to the 1st? It is not formatted for simple copy and paste.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
highlight sheet 2 data and edit-copy
go to A1 of sheet 1 and click edit-pastespecial-transpose(bottom right see)