Need help on condensing a table of info in Excel 2007

[shapenote]

I have spreadsheet with several columns (20) and rows (80) of data (i.e. almost like a pivot table). I need to condense it into 3.

i.e.:
300100 3001001 300102
1000001 $500.00 $100.00 $ 10.50
1000002 $600.00 $500.00 $150.75
1000003 $700.00 $200.00 $385.50

So I need to get this so it 3 columns of data as so:

300100 1000001 $500.00
300100 1000002 $600.00
300100 1000003 $700.00
300101 1000001 $100.00
300101 1000002 $500.00
etc.

 

[GlennUK]

Look at this method:

http://www.tek-tips.com/faqs.cfm?fid=5287