Sorry I think the correct word that explain what I mean is interleaved
not intersect.

Anyway think that the values in the coloumns A and B are timing values,
I have to create a coloumn C that contains the values of A and B but in
the correct timing order.

Can you help me on that?

Thanks again
BR,
Ale
Otto Moehrbach wrote:
Jessie
What does "intersect" mean? I know what the word means. What I want to
know is what does it mean in the context you are using it?
What does C1-x mean? HTH Otto
"jessie" wrote in message
ups.com...
Hi guys,

I am not so expert using excel so I need your help for this simple
problem.

What I have to do is to intersect the values contained in two coloumns
in a third coloumn.

For ex:

A1 - 1 B1-4
A2 - 3 B2-2
A2 - 5 B3-6
A2 - 7 B4-8
A2 - 9 B5-10

The result of coloumn C should be (the condition is that the values of
A,B coloumns have to be put in sequence in the coloumn C)

C1-1
C2-2
C3-3
C4-4
C5-5
C6-6
.......

Anyone know how to do that using an excel formula or macro?

Thanks in advance to all.
BR,
Jessie