Convert Data to Single Column with blank rows in between

[exc4libur]

Hi guys

I am studying for the gmat and I have put together a question bank to study for later.
I need to place all questions from the data table into a single column and in between each question I need to insert 10 or more blank rows so I will have plenty of space to workout out each question.

Please find attached a sample workbook.

Many thanks!
Best Rgds,
Exc4.

 

[SirJB7]

Hi, esx4libur!

No macro required, just a normal non-array formula.

In any column of any worksheet at row 1:
=SI(RESIDUO(FILA();12)=1;INDICE(Wanted!H:H;ENTERO(FILA()/12)+1;1)&" - "&INDICE(Wanted!I:I;ENTERO(FILA()/12)+1;1);SI(RESIDUO(FILA();12)=2;INDICE(Wanted!J:J;ENTERO(FILA()/12)+1;1);"")) -----> in English:
=IF(MOD(ROW(),12)=1,INDEX(Wanted!H:H,INT(ROW()/12)+1,1)&" - "&INDEX(Wanted!I:I,INT(ROW()/12)+1,1),IF(MOD(ROW(),12)=2,INDEX(Wanted!J:J,INT(ROW()/12)+1,1),""))

Copy down thru row 2340.

Regards!

 

[exc4libur]

Hi, esx4libur!

No macro required, just a normal non-array formula.

In any column of any worksheet at row 1:
=SI(RESIDUO(FILA();12)=1;INDICE(Wanted!H:H;ENTERO(FILA()/12)+1;1)&" - "&INDICE(Wanted!I:I;ENTERO(FILA()/12)+1;1);SI(RESIDUO(FILA();12)=2;INDICE(Wanted!J:J;ENTERO(FILA()/12)+1;1);"")) -----> in English:
=IF(MOD(ROW(),12)=1,INDEX(Wanted!H:H,INT(ROW()/12)+1,1)&" - "&INDEX(Wanted!I:I,INT(ROW()/12)+1,1),IF(MOD(ROW(),12)=2,INDEX(Wanted!J:J,INT(ROW()/12)+1,1),""))

Copy down thru row 2340.

Regards!

Perfect!!! Thank you very much Sir!!

 

[SirJB7]

Hi, exc4libur!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!
PS: If you had included column K data in the required output, probably I would have skipped this post. Good luck!