From the new Functions TOROW TOCOL CHOOSEROWS CHOOSECOLS

Excel file teaching how to perform New Functions: TOROW, TOCOL, CHOOSEROWS, CHOOSECOLS operation.

Excel Template for From the New Functions Torow Tocol Chooserows Choosecols

With TOROW and TOCOL, intervals are reduced to a single dimension. CHOOSEROWS and CHOOSECOLS are used to select rows and columns. Powerful combinations for dynamic reporting are illustrated.

Hope it is useful.