Copy from one excel spreadsheet to another

Closed
PatrickMarshall - Dec 29, 2009 at 08:16 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 30, 2009 at 06:08 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 30, 2009 at 06:08 AM
highlight sheet 2 data and edit-copy
go to A1 of sheet 1 and click edit-pastespecial-transpose(bottom right see)
0