Transpose Macro for single line consolidation

Hello :)

I am brand new to Excel macro programming - I am a SAS guy from experience.

I have an interesting transpose question.

I need my table to go from this:


Acct Order_qty Order_amt Date
1 15 $300 4/23/2007
1 12 $300 5/21/2007
1 13 $300 5/29/2007
2 10 $300 7/15/2008
2 9 $300 9/14/2008
2 10 $300 3/16/2009
3 17 $300 4/15/2007
3 17 $300 9/13/2010

To this:

Acct Order_qty1 Order_qty2 Order_qty3 order_amt1 order_amt2 order_amt3 Date_1 Date_2 Date_3
1 15 12 13 $300 $300 $300 4/23/2007 5/21/2007 5/29/2007
2 10 9 10 $300 $300 $300 7/15/2008 9/14/2008 3/16/2009
3 17 17 - $300 $300 - 4/15/2007 9/13/2010 -

What I would really like is to consolidate each account number to one line and then transpose the corresponding information with the suffix at the end!

If anyone can figure this out that would be great! Thanks guys!

I've also attached the book in case the forum text doesn't work out.