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

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