A B C D E F G
1 aa 1x 2x 3x 4x 5x 6x
2 aa1 f o n
3 aa2 a r d o d b
4 aa3 i n ch be x

then using combination of xl embbedded function only, follow bellow.
f
o
n
a
r
d
o
d
b
i
n
ch
be
x

namely, change sequential column value to row value ???
not user defined function, but embedded excel function only...

*** Sent via Developersdex http://www.developersdex.com ***