Below is a possible solution to the challenge – Challenge 33 – Convert Matrix into Linear Column – II.
Enter below formula and drag down –
=IF(OFFSET($A$1,MOD(ROWS($1:1)-1,COUNTA($A:$A)),ROUNDUP(ROWS($1:1)
/COUNTA($A:$A),0)-1)=0,"",OFFSET($A$1,MOD(ROWS($1:1)-1,COUNTA($A:$A)),
ROUNDUP(ROWS($1:1)/COUNTA($A:$A),0)-1))
The workbook containing the above solution can be downloaded from Solution – Challenge 33 – Convert Matrix into Linear Column – II.