Transposing cells

You're welcome. By the way, if this isn't just a one-time thing, you should probably define dynamic named ranges to use in these formulae:
In Name Manager - AppNumbers as formula =OFFSET(Sheet1!$A$1,4,0,COUNTA(Sheet1$A:$A)-4) would refer to A5:A??
Assuming you made your results range big enough, and there are no blanks in the defined area, this would automatically adjust to changing list size.
(NOTE: Offsetting from a cell OUTSIDE of the data (usually the header) keeps the reference intact even if the ENTIRE Data Range is deleted.)