"PierreL" wrote...
I have a table that reads
a b c
d e

I would like to map it to
a
b
c
d
e
Can I do this with a function?

Another alternative if the result would appear in a range of cells. If the
source range were named Src, and the top-left cell in the destination range
named Dest, enter the following formula in Dest

=OFFSET(Src,INT((ROW()-ROW(Dest))/COLUMNS(Src)),
MOD(ROW()-ROW(Dest),COLUMNS(Src)),1,1)

and fill this cell down as far as needed.