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
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