one way would be to copy / past special + Transpose 1-6 into colum B. In
column A put 1 through 6. Then copy a-f and in B7 past special + transpose
and next in column A put 1 through 6 beside a-f. Then you can sort by A to
get it in the order you need.

If you have a larger list, you can setup a macro to do this and have the
first set 1-1000 with a formula doing the ordering and 1001-2000 for the next
set, copy past special to another sheet and sort.

I think the "offset" function could help here also?

"IUM" wrote:

I would like to set up a simple formula turn the follow array into a single
column:

123456
abcdef

result:
1
a
2
b
3
c
4
d
5
e
6
f
Thank you.