Copy set of values to different cell

September 14, 2011 at 07:55:00
Specs: Windows Vista
Can some body help?

How can i copy a set of values to different cells. E.g. I have these numbers that keep occurring periodically in a column. And i want to copy each set of values (4 of them each) to a new column. E.g. So i have in one column with these values

A
B
C
D

E
F
G
H

they are about 100 of such set of values. And i want to copy them to look like this.

A E I
B F J
C G K
D H L

Who can help? Is there any function that can do this or i need to write a macro?

I tried using a macro that i recorded, but I got an error saying too macro too large.

Any hints?


See More: Copy set of values to different cell

Report •

#1
September 14, 2011 at 15:09:10
Is there really an empty row between the 4th and 5th value?

If so, is there an empty row between every set of 4 values?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question