Trying to duplicate data

[neonlights]

I need excel to refer data in cell A1 and duplicate it multiple times in next column, cell A2 and duplicate it multiple time below the first set etc.

Ex:

1	1
2	1
3	1
4	1
5	1
	2
	2
	2
	2
	2
	3
	3
	3
	3
	3
	4
	4
	4
	4
	4
	5
	5
	5
	5
	5

[Sam Capricci]

you could try =index(A:A,roundup(row(A1)/4,0)) assuming you want those repeated four times each.
in cell B1 then dragged down.

[neonlights]

Thanks Sambo kid; it helped.

*ed