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?
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?