How to Separate a Column of data by the same number of rows?

Hi,

I need to basically have each number in my column (B) be split apart by the same number of blank cells (Column F). Preferred if it would also copy each number into those blank cells (Column H). Thanks!

ExamplePic1.PNG

Try these two

=IFERROR(IF(MOD(ROWS(A$1:A3),3)+1=1,INDEX($B$2:$B$4,INT(ROWS(A$1:A3)/3)),""),"")

and

=IFERROR(INDEX($B$2:$B$4,INT(ROWS(A$1:A3)/3)),"")

Row\Col	B	C	D	E
2	111		111	111
3	112			111
4	113			111
5			112	112
6				112
7				112
8			113	113
9				113
10				113

You could try simply to copy and paste these formulas. Just make sure that
111
112
113

is in B2:B4