Hi, all my data from
A1 TO Z1 is across and now I want to paste down from A1 to A26
A1:Z1 = 12345678910.......26
to
A1:1
A2:2
A3:3
...... A26:26
any idea how this work? thank you
Hi, all my data from
A1 TO Z1 is across and now I want to paste down from A1 to A26
A1:Z1 = 12345678910.......26
to
A1:1
A2:2
A3:3
...... A26:26
any idea how this work? thank you
Last edited by Exxcel Noob; 05-11-2012 at 11:50 AM.
Copy range B1:Z1
Select A2 and Paste Special - Transpose
You're welcome. Don't forget to mark your thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks