Move Multiple-Column Data to One Column (not Transpose)

**NBVC** · 05-03-2011, 07:42 AM

assuming you still want a blank row between groups, then again in the 16th row enter space in each of the cells and then try:

=INDEX($A$1:$D$16,MOD(ROWS($A$1:$A1)-1,16)+1,CEILING(ROWS($A$1:$A1),16)/16)

**CriticalEric** · 05-03-2011, 09:39 AM

Originally Posted by NBVC

assuming you still want a blank row between groups, then again in the 16th row enter space in each of the cells and then try:

=INDEX($A$1:$D$16,MOD(ROWS($A$1:$A1)-1,16)+1,CEILING(ROWS($A$1:$A1),16)/16)

You're the best

I was over-thinking when trying to adapt your formula.

Kind Regards,
Eric