Convert list of unique values into multiples quickly

[lukiebabie]

HI guys

Basically my problem is that i need to convert a list of unique values into a list of the same values duplicated several times.

A small example is; I need to change the list:

Item1
Item2
Item3
Item4

So that each item is shown four times;

Item1
Item1
Item1
Item1
Item2
Item2
Item2
Item2

etc...

Any advice welcome.

Cheers

[Fotis1991]

Hi

With your starting in A2(A1=Title); put this formula, where you want and copy down.

=INDEX($A$2:$A$1000;CEILING(ROW(A1)/4;1))

Is this, works for you?

[icestationzbra]

if your values you want to repeat are in A1:A4, put this formula in any cell in any other column and drag down:

=INDEX($A$1:$A$4,INT((ROW($A1)-1)/2)+1)

this will repeat a value 2 times. if you want to repeat every value 4 times:

=INDEX($A$1:$A$4,INT((ROW($A1)-1)/4)+1)

[lukiebabie]

Fantastic. Big thanks to both of you.

Cheers

[icestationzbra]

if your query has met resolution, please set the thread status to Solved.

Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.