difficult function
 

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 ***

difficult function
 

what's the question?
cut/copy
paste special
transpose

this will paste a row to a column or column to a row
Dave

difficult function
 

i want to make it with the function in embbeded in xl.

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