Column to table format

[Bonita]

Data imported into excel in the following format
order A
sales 100
qty 50

order B
sales 200
qty 500

How do I convert to the following format?
order sales qty
a 100 50
b 200 500

Any help will be greatly appreciated.....

 

[Frank Kabel]

Hi
on a separate sheet enter the following formula in A2:
=OFFSET('sheet1'!$A$1,(ROW(1:1)-1)*3+COLUMN(A:A)-1,0)
and copy this down and to the right.

If you have a blank row between the records use:
=OFFSET('sheet1'!$A$1,(ROW(1:1)-1)*4+COLUMN(A:A)-1,0)