Hi, I think there must be an easy way to do this!

I have several columns and two rows of data, so for example:

ABC DEF GHI JLK
123 456 789 101112

and I want to transpose it into one column like this

123
ABC
456
DEF
789
GHI
101112
JLK

I have tried a pivot table, however I need the numbers first then the letters, (in alphabetical order). Its not as easy as just using the copy and paste transpose functions, so there must be some sort of formula??!!

Thanks