Merging Invoice line items

[Nicholson]

I have data that has several line items with the same invoice numbers but with different values. I tried to pivot and it doesn't work. For example:
1. INV12345 Gross Sales 100.00 Discount 0 Shipping 0 Tax 0
2. INV12345 Gross Sales 0 Discount -20.00 Shipping 0 Tax 0
3. INV12345 Gross Sales 0 Discount 0 Shipping 15.00 Tax 13.50

How can I get the invoices to Fully merge? I need one line INV12345 Gross Sales 100.00 Discount -20.00 Shipping 15.00 Tax 13.50

Is this possible? I have thousands of lines (various invoices) that need to be merged , if possible

 

[ValuationMan]

The pivot table should work. How did you setup your fields?

 

[Nicholson]

The pivot table should work. How did you setup your fields?

I realize now I had a filter on. Totally drove myself nuts for no reason!

 

[ValuationMan]

That's my colleagues call a picnic (problem in chair, not in computer). Glad you found it out!