Spread data by numbers

[KingTamo]

There are data in first column.. A - B - C and I am wanting to get the data spread as in column J four times for each data by the number in F2
then in column K to take each four values by the same order

[Bo_Ry]

Please try at J2

=INDEX($A$2:$A$9,(ROWS(J$2:J2)-1)/$F$2+1)&""

[KingTamo]

Thank you. Can column K have formula too?

[Bo_Ry]

Please try at K2
=IF(J2="","",ROWS(J$2:J2))

[KingTamo]

Thanks but this doesn't work with the real data. The real data in column B are numbers like 100,150,200,10010,952 etc.

[bebo021999]

Thank you. Can column K have formula too?

Simply with:

K2=B2

?? or I missed something?

[KingTamo]

Thanks but I like that to be dynamic based on the values in D2 to F2

[KingTamo]

Please need help.

[JeteMc]

The real data in column B are numbers like 100,150,200,10010,952 etc.

I like that to be dynamic based on the values in D2 to F2

Perhaps if you could more thoroughly explain the meaning of the two statements then we would have a better idea of how to help.
Better yet, manually illustrate how numbers like 100,150,200,10010,952 etc. in column B should be used in column K, based on the values in D2 to F2, by uploading another .xlsx file.
Let us know if you have any questions.

[KingTamo]

What I mean is to distribute the data by the number in cell F2.

[AliGW]

Please upload a workbook with more realistic data clearly showing the sort of output you require.

[JeteMc]

What I mean is to distribute the data by the number in cell F2.

Try the following array entered formula** in cell K2 and then drag the fill handle down: =INDEX(B$2:B$9,(ROWS(K$2:K2)-1)/$F$2+1)
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Let us know if you have any questions.

[KingTamo]

Thanks a lot. It seems not the desired result. Please have a look at the desired result in the first attachment.
I am so sorry.

[JeteMc]

As modeled in the attached copy of the file, Bebo's solution will replicate the values in column K. If the values are changed to those listed in post #5 it still works.
Let us know if you have any questions.

[KingTamo]

Thanks a lot. As for column j is okay but column k, I don't need equals directly but to distribute each four numbers with another way to get the same result.