Spreadsheet: 873481d1719968658-how-to-combine-daily-sales-remaining-stock-into-one-table-combine-akir4-
Sheet: Sheet1

 | NO | Order Number | 2024-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Warehouse stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Order Number | Name | Stock in |  |  | Stock Out |  |  | Remaining Stock
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME] |  |  |  |  | Orange | [NAME] | Mango | Orange | [NAME] | Mango | Orange | [NAME] | Mango
 |  |  |  |  | Orange | [NAME] | Mango |  |  |  |  |  |  | 2024-06-30 00:00:00 |  | Remaning Stock in june | 51 | 51 | 51
 | 1 | 33-1525 | [NAME] | 60123123123 | 9 | 9 |  | 1980000 | 546000 |  | DONE |  |  | 2024-07-01 00:00:00 | 33-1525 | [NAME] |  |  |  | 9 | 9
 | 2 | 33-1526 | [NAME] | 61789456123 | 3 | 3 | 3 | 999000 | 24000 |  | DONE |  |  | 2024-07-01 00:00:00 | 33-1526 | [NAME] |  |  |  | 3 | 3 | 3
 | 3 | 33-1527 | [NAME] | 68456123789 | 6 | 6 | 6 | 1980000 | 200000 |  | DONE |  |  | 2024-07-01 00:00:00 | 33-1527 | [NAME] |  |  |  | 6 | 6 | 6
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 33-1528 | Amazon |  |  |  | 9 | 9
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 33-1529 | Alibaba |  |  |  | 3 | 3 | 3
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00 | 33-1530 | [NAME] |  |  |  | 3 | 3 | 3
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00 | 33-1531 | veronia |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00 | 33-1532 | olivia |  |  |  | 12 |  | 12
 |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00 | 33-1533 | Amazon |  |  |  | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00 |  | Restocking | 80 | 80 | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00 | 33-1534 | Alibaba |  |  |  |  |  | 9
 | NO | NO.ORDER | Online Application |  |  |  |  |  |  |  |  |  |  | 2024-07-03 00:00:00 | 33-1535 | [NAME] |  |  |  | 3 | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-03 00:00:00 | 33-1536 | phei |  |  |  |  | 6 | 6
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME] |  | 2024-07-03 00:00:00 | 33-1537 | [NAME] |  |  |  |  | 10 | 9
 |  |  |  |  | Orange | [NAME] | Mango |  |  |  |  |  |  | 2024-07-03 00:00:00 | 33-1538 | Amazon |  |  |  | 9
 | 1 | 33-1528 | Amazon | 6017896355 | 9 | 9 |  | 1980000 | 546000 |  | DONE |  |  | 2024-07-04 00:00:00 | 33-1540 | [NAME] |  |  |  | 6
 | 2 | 33-1529 | Alibaba | 3048798456 | 3 | 3 | 3 | 999000 | 24000 |  | DONE |  |  | 2024-07-04 00:00:00 | 33-1541 | [NAME] |  |  |  |  | 3
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-04 00:00:00 | 33-1542 | [NAME] |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-04 00:00:00 | 33-1543 | Amazon |  |  |  |  | 6
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-04 00:00:00 | 33-1544 | Alibaba |  |  |  | 3
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 | 33-1545 | [NAME] |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 | 33-1546 | phei |  |  |  | 3 | 3 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 | 33-1547 | [NAME] |  |  |  | 6
 |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 | 33-1548 | Amazon |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 | 33-1549 | Alibaba |  |  |  | 24 | 12 | 12
 | NO | Order Number | 2024-07-02 00:00:00
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME] |  | Warehouse stock
 |  |  |  |  | Orange | [NAME] | Mango |  |  |  |  |  |  | Date | Order Number | Name | Stock in |  |  | Stock Out |  |  | Remaining Stock
 | 1 | 33-1530 | [NAME] | 8190216663 | 3 | 3 | 3 | 999000 |  | 999000 | DONE |  |  |  |  |  | Orange | [NAME] | Mango | Orange | [NAME] | Mango | Orange | [NAME] | Mango
 | 2 | 33-1531 | veronia | 811648333 |  | 6 |  | 699000 | 39000 | 738000 | DONE |  |  | 2024-06-30 00:00:00 |  | Remaning Stock in june | 51 | 51 | 51
 | 3 | 33-1532 | olivia | 898257948 | 12 |  | 12 | 2679000 | 240000 | 2919000 | DONE |  |  | 2024-07-01 00:00:00
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00
 |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00
 | NO | NO.ORDER | Online Application |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-02 00:00:00
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME] |  | 2024-07-02 00:00:00
 |  |  |  |  | Orange | [NAME] | Mango |  |  |  |  |  |  | 2024-07-03 00:00:00
 | 1 | 33-1533 | Amazon | GM-643 | 3 | 3 |  | 720000 | 546000 |  | DONE |  |  | 2024-07-03 00:00:00
 | 2 | 33-1534 | Alibaba | kelntai signature |  |  | 9 | 999000 | 24000 |  | DONE |  |  | 2024-07-03 00:00:00
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-03 00:00:00
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-04 00:00:00
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-04 00:00:00
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-04 00:00:00
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-04 00:00:00
 |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00
 | NO | Order Number | 2024-07-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME]
 |  |  |  |  | Orange | [NAME] | Mango
 | 1 | 33-1535 | [NAME] | 8190098248 | 3 | 3 | 3 | 999000 | 150000 |  | DONE
 | 2 | 33-1536 | phei | 8216959254 |  | 6 | 6 | 1359000 | 11000 |  | DONE
 | 3 | 33-1537 | [NAME] | 8218552460 |  | 10 | 9 | 1980000 | 13500 |  | DONE
 | 4
 | 5
 | 6
 | 7
 |  | TOTAL
 | NO | NO.ORDER | Online Application
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME]
 |  |  |  |  | Orange | [NAME] | Mango
 | 1 | 33-1538 | Amazon | 601789355 | 9 |  |  | 999000 |  |  | DONE
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 |  | TOTAL
 | NO | Order Number | 2024-07-04 00:00:00
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME]
 |  |  |  |  | Orange | [NAME] | Mango
 | 1 | 33-1540 | [NAME] | 60123123123 | 6 |  |  | 699000 | 18500 |  | DONE
 | 2 | 33-1541 | [NAME] | 61789456123 |  | 3 |  | 360000 |  |  | DONE
 | 3 | 33-1542 | [NAME] | 68456123789 |  | 3 |  | 360000 | 30500 |  | DONE
 | 4
 | 5
 | 6
 | 7
 |  | TOTAL
 | NO | NO.ORDER | Online Application
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME]
 |  |  |  |  | Orange | [NAME] | Mango
 | 1 | 33-1543 | Amazon | 6017896355 |  | 6 |  | 699000 |  |  | DONE
 | 2 | 33-1544 | Alibaba | 3048798456 | 3 |  |  | 360000 |  |  | DONE
 | 3
 | 4
 | 5
 | 6
 | 7
 |  | TOTAL
 | NO | Order Number | 2024-07-05 00:00:00
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME]
 |  |  |  |  | Orange | [NAME] | Mango
 | 1 | 33-1545 | [NAME] | 8190098248 | 6 |  |  | 699000 | 18000 |  | DONE
 | 2 | 33-1546 | phei | 8216959254 | 3 | 3 | 9 | 1698000 | 23000 |  | DONE
 | 3 | 33-1547 | [NAME] | 8218552460 | 6 |  |  | 699000 |  |  | DONE
 | 4
 | 5
 | 6
 | 7
 |  | TOTAL
 | NO | NO.ORDER | Online Application
 |  |  | Name | Phone Number | Variant |  |  | Price | Transport fee | TOTAL | Pay | [NAME]
 |  |  |  |  | Orange | [NAME] | Mango
 | 1 | 33-1548 | Amazon | 6017896355 |  | 3 |  | 360000 |  |  | DONE
 | 2 | 33-1549 | Alibaba | 3048798456 | 24 | 12 | 12 |  |  |  | DONE
 | 3
 | 4
 | 5
 | 6
 | 7
 |  | TOTAL