» Transposing a Range in Ascending Order

Problem:

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.

Solution:

Use the SMALL and COLUMN functions as shown in the following formula and enter the formula in cells E1:I1:
=SMALL($A$2:$A$6,COLUMN()-COLUMN($E$1)+1)
Then, use the INDEX and MATCH functions as shown in the following formula and enter the formula in cells E2:I2:
=INDEX($B$2:$B$6,MATCH(E1,$A$2:$A$6,0))