I'm missing something here. For a 3x3 array, both formulas for column B work. But if I change it to a 4x6 array, the values found for column B start over after the first four values. The formula I'm using is:
=INDEX($B$1:$G$1,MOD((ROW()-5-QUOTIENT(ROW()-1,COUNTA($B$1:$G$1))*COUNTA($B$1:$G$1)),ROWS($A$2:$A$5))+1)