I have 55,000 rows of order data, some orders may have up to 8 rows associated based on each item that was for that order. For example:

Order # Cust # Contact Name Date Order Type Item # Item Desc Qty List Price
3215616 10003 Will Biles 9/1/11 New Biz 68-55 Tuna Hook 1 114.1
3215616 10003 Will Biles 9/1/11 New Biz 68-57 Tuna Remover 1 72.32
3215616 10003 Will Biles 9/1/11 New Biz 68-64 Tuna Cleaner 4 8.57

What I want to do is compare the order number and then based on that move the item#, Item Desc, Qty, and List Price for each to a new column along with the Order #, Cust #, Name, Date, and Order Type to create on column of data for each order number but with all the items information. See Below

Order# *Cust#*Name*Date*Type *Item # *Item Desc* Qty* Price *Item# *Item *Desc *QTY *Price *Item# *Item Desc *QTY * Price

I would really appreciate the help! Thank you!