» Transposing an Entire Range of Data into a Single Column

Problem:

Transposing all the values from Data Range (cells B3:E5) into a single column.

Solution:

To process the values in Data Range from left to right (i.e. row by row):
Use the OFFSET, INT, ROW, and MOD functions as shown in the formula in cell H3:
=OFFSET($B$3,INT((ROW()-ROW($H$3))/4),MOD(ROW()-ROW($H$3),4))

To process the values in Data Range from top to bottom (i.e. column by column):
Use the OFFSET, MOD, ROW, and INT functions as shown in the following formula in cell I3:
=OFFSET($B$3,MOD(ROW()-ROW($I$3),3),INT((ROW()-ROW($I$3))/3))