» Transposing a Range in Ascending Order
Columns A & B contain a list of client payments, and the dates they were made.
We want to transpose the data from columns A & B (cells A2:B6) into rows 1 & 2 (E1:I2). In doing so, the payments are to be sorted from earliest to latest.
Use the SMALL and COLUMN functions as shown in the following formula and enter the formula in cells E1:I1:
Then, use the INDEX and MATCH functions as shown in the following formula and enter the formula in cells E2:I2: