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