If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook:

=ArrayReshape(A1:D3,12,1,1) array entered into a 12-cell column

Alan Beban

Mark wrote:
Was wondering if there is a simple way to re-arrange data with some VB code.
I have much more data than in the following example.
So this could actually save several hours of work.

Thanks in advance, Mark

Have data in this format:

BOB DAVE JIM HAROLD
1 33 31 15
19 23 22 99

I need it in this format:

BOB
1
19
DAVE
33
23
JIM
31
22
HAROLD
15
99