I have data exported from a POS that is listed downways with common Invoice number. What i need is to have it listed on a single row for each invoice.
Current data
<tbody>
</tbody>
What i need to look like:
Invoice W1036IN1554 and all related data listed on a single row.
Current data
District | Invoiced At | Sold On | Invoice # | Sold By | Customer | Product SKU | Product Name | Tracking # | Refund | Qty | Gross Profit | Category | Contract # |
City | New York | 8/1/2017 | W1036IN15547 | John Smith | Customer Name (differnet per invoice) | CAOTVZ000203 | 4G LTE 3FF NFC SIM CARD | No | 1 | 15.72 | >> Accessory >> Other >> SIM Cards | ||
City | New York | 8/1/2017 | W1036IN15548 | John Doe | Customer Name (differnet per invoice) | AYSPAF000429 | FIXURCRACK IPHONE 7 TEMPERED GLASS | No | 1 | 8 | >> Accessory >> Screen Protection >> Tempered Glass >> Generic Tempered Glass >> Smartphone Generic TG | ||
City | New York | 8/1/2017 | W1036IN15549 | John Smith | Customer Name (differnet per invoice) | FESFNS000035 | READY?GO! PACKAGE | 3253674519 | No | 1 | 24.95 | >> Fees >> Service Fees | |
City | New York | 8/1/2017 | W1036IN15550 | Charles Smith | Customer Name (differnet per invoice) | CAOTVZ000203 | 4G LTE 3FF NFC SIM CARD | No | 1 | 15.72 | >> Accessory >> Other >> SIM Cards | ||
City | New York | 8/1/2017 | W1036IN15551 | Joe Who | Customer Name (differnet per invoice) | AYPRAF000262 | FIX UR CRACK 2.1A CARPORT | No | 1 | 32.09 | >> Accessory >> Power >> Carport >> Generic Carports | ||
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZAP002496 | APPLE IPHONE 7 128GB - ROSE GOLD (MNAM2LLA) | 355830087480936 | No | 1 | 0 | >> Activations >> Verizon Wireless >> Equipment >> Apple iPhones >> Apple iPhone - New | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZRB002329 | DPP Phone Rebate | 2193849338 | No | 1 | 0 | >> Activations >> Verizon Wireless >> Phone Rebates (VZ Commission) >> Device Payment (Reimbursement) | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZNS000410 | iPhone Rate Plan (Device Payment) | No | 1 | 0 | >> Activations >> Verizon Wireless >> Rate Plans | 168533884 | |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZRB002321 | Device Payment Upgrade iPhone (Rate Plan Rebate) | 2193849338 | No | 1 | 150 | >> Activations >> Verizon Wireless >> Rate Plan Rebates | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZRB002691 | ASURION - DPP NEW SPF | 2193849338 | No | 1 | 70 | >> Activations >> Verizon Wireless >> Features >> Features - SPF | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZRB002697 | ASURION - DPP Dropped\Renewal | 2193849338 | Yes | -1 | -30 | >> Activations >> Verizon Wireless >> Features >> Features - No SPF | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZRB002761 | ASURION - Renewal Tracker | 2193849338 | No | 1 | 0 | >> Activations >> Verizon Wireless >> Features >> Features - No SPF | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZRB002665 | TMP - NON ANDROID SMARTPHONE (NEW) | 2193849338 | No | 1 | 0 | >> Activations >> Verizon Wireless >> Features >> Features - SPF | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZRB002671 | TMP - ANDROID SMARTPHONE (DROPPED) | 2193849338 | No | 1 | 0 | >> Activations >> Verizon Wireless >> Features >> Features - No SPF | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZNS002316 | Installment Loan Number | 1045546270 | No | 1 | 0 | >> Activations >> Verizon Wireless >> Integration SKUs >> Other Installment SKUs | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZNS002315 | Installment Financed Amount | 2193849338 | Yes | -1 | -760 | >> Activations >> Verizon Wireless >> Integration SKUs >> Installment Offset | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZRB002318 | Installment Financing Fee | 2193849338 | Yes | -1 | -38 | >> Activations >> Verizon Wireless >> Integration SKUs >> Other Installment SKUs | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | CLVZRB002317 | Installment Rebate Amount | 2193849338 | No | 1 | 760 | >> Activations >> Verizon Wireless >> Integration SKUs >> Other Installment SKUs | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | FESFNS000035 | READY?GO! PACKAGE | 2193849338 | No | 1 | 24.95 | >> Fees >> Service Fees | 168533884 |
City | New York | 8/1/2017 | W1036IN15552 | John Smith | Customer Name (differnet per invoice) | AYCSLI002440 | LIFEPROOF IPHONE 7 FRE SUNSET BAY | No | 1 | 31.24 | >> Accessory >> Cases >> Rugged Cases | ||
City | New York | 8/1/2017 | W1036IN15553 | John Smith | Customer Name (differnet per invoice) | AYPRWA000268 | W&A 2.4AMP WALLPORT | No | 1 | 15.35 | >> Accessory >> Power >> Wallport >> Generic Wallports | ||
City | New York | 8/1/2017 | W1036IN15553 | John Smith | Customer Name (differnet per invoice) | AYPRWA000266 | W&A 6FT LIGHTNING CABLE BLACK | No | 1 | 24.02 | >> Accessory >> Power >> Cables >> Lightning Cables | ||
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | CLVZAP000208 | APPLE IPAD MINI RETINA 16GB SPACE GRAY (MF069LLA) | 358849057012039 | No | 1 | -155.5 | >> Activations >> Verizon Wireless >> Equipment >> Tablets >> Apple Tablets >> Apple Tablets - New | 165533960 |
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | CLVZRB000399 | 2 YR New iPad | 4443411840 | No | 1 | 200 | >> Activations >> Verizon Wireless >> Phone Rebates (VZ Commission) >> New Activation (VZ Commission) | 165533960 |
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | CLVZNS000066 | New Activation Rate Plan | No | 1 | 0 | >> Activations >> Verizon Wireless >> Rate Plans | 165533960 | |
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | CLVZRB000069 | New Activation (Rate Plan Rebate) | 4443411840 | No | 1 | 0 | >> Activations >> Verizon Wireless >> Rate Plan Rebates | 165533960 |
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | CLVZRB002692 | ASURION - 2 YR NEW SPF | 4443411840 | No | 1 | 60 | >> Activations >> Verizon Wireless >> Features >> Features - SPF | 165533960 |
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | CLVZNS002838 | VZW INSTANT DISCOUNT TABLET PROMO | Yes | -1 | -100 | >> Activations >> Verizon Wireless >> Additional Spiffs (Promotions) >> REV Other VZ Promotions | 165533960 | |
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | CLVZRB002839 | VZW INSTANT DISCOUNT TABLET PROMO GP | 4443411840 | No | 1 | 100 | >> Activations >> Verizon Wireless >> Additional Spiffs (Promotions) >> Other VZ Promotions | 165533960 |
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | CLVZRB002656 | TMP - BASIC/IPAD/JETPACK (NEW) | 4443411840 | No | 1 | 0 | >> Activations >> Verizon Wireless >> Features >> Features - SPF | 165533960 |
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | AYCSOT000336 | OTTERBOX IPAD MINI/2/3 PROFILE MOONLESS NIGHT | No | 1 | 8.09 | >> Accessory >> Cases >> Folio Cases | ||
City | New York | 8/1/2017 | W1036IN15554 | John Smith | Customer Name (differnet per invoice) | FESFNS000035 | READY?GO! PACKAGE | 4443411840 | No | 1 | 24.95 | >> Fees >> Service Fees |
<tbody>
</tbody>
What i need to look like:
Invoice W1036IN1554 and all related data listed on a single row.