how do i rework the sequence of data

hi all,
i need help sequencing my data... i have 2 lists
List 1 List 2
a 1
b 2
c 3
d 4
e 5
f 6
g 7
h 8
i 9
j 10

i want to sequence them so that i get
List 3
a
1
b
2
c
3
d
4
... and so on...pls advice
ranjan

Hi
I am not sure that data you have shown is the original data. (However I consider it original data)

copy list 2 and paste at the bottom of the same list (i-e if list 2 is in B1:B10, copy it and paste it in B11:B20)
then select both lists and sort according to list 2 (you will have a blank cell between each data cell in list 1)
select list 1, press F5, click Special button and check Blanks. (it will select blank cells in list 1).
now press = (equal sign) then right arrow key and press Ctrl+Enter.

let me know if it helps.

Originally Posted by ranjan

thanks, i tried what u told me...works fine only if i have mutually exclusive data which is non repetative. what if the list has same data repeating its self???

pls advice
ranjan

Hi,

try in C1

=OFFSET($A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))

and formula fill that as far down as required, then
copy column C and Paste Special = Values back over itsself.
remove columns A and B

hth
---