undo alt+enter

I inherited a great worksheet that I'd like to take to access. It's a
pricing sheet. A whole year's worth data.

Date,customer,item, price, etc. 
Like: 9/9/99, greatcustomer, 1111alt+enter2222alt+enter (sometimes up
to 10 times), price 1111alt+enter2222alt+enter (always matches
customer column), etc.

I added a column to each row and entered a unique number to each
transaction.
I'd like to convert each sheet to: at each change of unique no, copy
[date,customer,item,price, etc]to another sheet. If Item, alt+enter,
then copy each instance on a separate row (together with the date,
customer, etc. information).

So if I start out with 5 rows. 3 of them havin 3alt+enter in item and
price. Then I end up with 11 rows.

 with items matching pricing 

Has anyone been through this?