Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

brsboarder

macrumors 6502a
Original poster
Feb 16, 2004
763
15
I need to take about 2000 cells that are in a column and transpose them into rows that are four cells long and aligned in a column. For example:

1, 12, 15, 18, 25, 36, 5, 25, 12, 89 is how they are now and I need

1, 12, 15, 18,
25, 36, 5, 25,
12, 89

I tried running a small macro, and it worked for say cells a1-e1 but it wouldnt just continue to do it for f and so on, so any help?
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.