Simple problem im sure....

hey,

Im tryign to transpose a column of values from vertical to horizontal. However I know how to do this but what I need is to r=transpose the values multiple times. i.e.

5325
5325i
5278

what I want is

5325 5325 5325 5325i 5325i 5325i 5278 5278 5278

ALthough I could go through an manually do this, I have a column of 50 references and wondered if anyone had a solution.
Thanks in advance......

Try this: With your original values in A2:A51

Put this formula where you want the transposed values to begin:
=INDEX($A$2:$A$51,CEILING(COLUMN(A1)/3,1))

and drag across

Thanks, I see what you did there, very cunning!

Cheers again