Is this a real live problem or a simplified version? Try something like:

=SMALL($B$1:$D$1,ROW(B2)-ROW(B$2)+1)

in cell A2 and then copy down.

--

Vasant



"cradino" wrote in message
...
I have in B1:C1 three number non-ordered
Like this:
B1:101
C1:103
D1.102

I want
In only one function transpose and order them to A2:A4
Like this:
A2:101
A3:102
A4:103

Can anybody help me?
Best regards
Cradino