single entry to double entry

**ice1980** · 04-21-2009, 12:40 PM

I would like to be able to go from a column like this:
apple
banana
cherry
diaper

and the next column to have:
apple
apple
banana
banana
cherry
cherry
diaper
diaper
Sounds simple, but I'm stumped. Help! Thanks!

**ConneXionLost** · 04-21-2009, 12:45 PM

Hi ice1980,

Copy A1:A4.
Paste in B1,
Paste again in B5,
Sort B.

Cheers,

**DonkeyOte** · 04-21-2009, 12:45 PM

If as you say A1:A4 hold

apple
banana
cherry
diaper

Then

B1: =INDEX(A:A,CEILING((ROWS(B$1:B1)-1)/2,1))
copied down as far as required

If you wanted apple three times change the divisor from 2 to 3 etc...