TerryP
11-19-2008, 09:45 AM
I have data in multiple columns like this :
<pre>
20707168 20933238 20476750 20562404
21016254 20921261 20560321 20930943
21016301 21084700 20934594 21337734
21342117 21328617 21349354 21215562
20854831 21112280 21354623 20854998
20856094 20856680 21131627 21022690
21335639 21358864 20976123 20982292
21277545 21174476 21288204 21204508
21357727 21040620 20856253 21304184
20980329 21268373 21049644 20856612
21202994 21274060 21364011 21032761
21349318 21336338 21174662 21337243
20929325 20560780 20856182 20562604
20563105 21334453 20964299 20907247
20855986 20551083 20538507 20915118
20969553 21169459 21032727 21171546
21096805 21097044 21267142 21128912
21226288 21292704 21309776 21311756
20975721 20941514 20979821 20942369
</pre>
I'd like to move all data to one single column (like column #1)
Can someone help me out with a VBA macro ?
Much appreciated
<pre>
20707168 20933238 20476750 20562404
21016254 20921261 20560321 20930943
21016301 21084700 20934594 21337734
21342117 21328617 21349354 21215562
20854831 21112280 21354623 20854998
20856094 20856680 21131627 21022690
21335639 21358864 20976123 20982292
21277545 21174476 21288204 21204508
21357727 21040620 20856253 21304184
20980329 21268373 21049644 20856612
21202994 21274060 21364011 21032761
21349318 21336338 21174662 21337243
20929325 20560780 20856182 20562604
20563105 21334453 20964299 20907247
20855986 20551083 20538507 20915118
20969553 21169459 21032727 21171546
21096805 21097044 21267142 21128912
21226288 21292704 21309776 21311756
20975721 20941514 20979821 20942369
</pre>
I'd like to move all data to one single column (like column #1)
Can someone help me out with a VBA macro ?
Much appreciated