Greetings. Using Excel 2010. I have 100 customer orders running across 100 columns. Each order has 4 rows of data. I want to maintain the data being in rows but I would like to eventually export/copy+paste one long list to Word or similar. Example:
CURRENTLY
A1 B1 C1 D1 etc.
A2 B2 C2 D2
A3 B3 C3 D3
A4 B4 C4 D4
DESIRED
A1
A2
A3
A4
B1
B2
B3
B4
C1
C2
C3
C4
D1
D2
D3
D4
etc.
Any suggestions?
Eric
Bookmarks