Transpose Array
 

Howdy:

I'd like to convert A1:D4


A B C
1 x x x
2 y y y
3 z z z

to Sheet2 A1:c9

A 1 x
A 2 y
A 3 z
B 1 x
B 2 y
B 3 z
C 1 x
C 2 y
C 3 z

Thank you

Transpose Array
 

Use reverse Pivot Table.
http://j-walk.com/ss/excel/usertips/tip068.htm
then sort by Column.