@Jeff
A more Generic Formula for any X, Y grid
=OFFSET(a,TRUNC((COLUMN(OFFSET(A1,,,,COLUMNS(a)*2))-1)/COLUMNS(a)),MOD(COLUMN(OFFSET(A1,,,,COLUMNS(a)*2))-1,COLUMNS(a)),1,1)
Returns
={1,2,3,"a","b","c",4,5,6,"d","e","f"}
How I wish Data...