Spreadsheet: 882081d1730357042-need-formula-sheet-2-to-take-the-data-from-the-sheet-1-unorganized-excel-data-sheet-2
Sheet: SHEET 2 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need formula here to take    data from sheet 1
 |  | Journal No | Source Code | Original Number |  |  | Journal Date | Distribution Reference |  |  | Reference |  | Debit Amount |  |  |  |  |  | Credit Amount |  | Balance |  |  |  |  |  |  | CT Number | Site Id |  | Total Price
 |  | 24010033 | CNSJV | CT-1111 |  |  | 14/01/2024 | Consumable Transaction CT-1111 |  |  |  |  | 605.5 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1111 | Nescafe 01Ctn / 12*200g |  | 380
 |  | 24010043 | CNSJV | CT-1244 |  |  | 14/01/2024 | Consumable Transaction CT-1244 |  |  |  |  | 530.43 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1111 | Red Tea CTN 24/100 |  | 196
 |  | 24010044 | CNSJV | CT-1245 |  |  | 14/01/2024 | Consumable Transaction CT-1245 |  |  |  |  | 758.95 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1111 | Sugar 10 KG |  | 29.5
 |  | 24010045 | CNSJV | CT-1516 |  |  | 14/01/2024 | Consumable Transaction CT-1516 |  |  |  |  | 407.2 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1244 | Cardamom |  | 130.43
 |  | 24010046 | CNSJV | CT-1590 |  |  | 14/01/2024 | Consumable Transaction CT-1590 |  |  |  |  | 1628 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1244 | Coffee Mate CTN/12*900g |  | 400
 |  | 24010047 | CNSJV | CT-1769 |  |  | 14/01/2024 | Consumable Transaction CT-1769 |  |  |  |  | 668 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1245 | [NAME] |  | 480
 |  | 24010138 | CNSJV | CT-1770 |  |  | 28/01/2024 | Consumable Transaction CT-CT-1770 |  |  |  |  | 558.27 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | CT-1245 | Cloves for Coffee |  | 52.95
 |  | Totals |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1245 | Nescafe 01Ctn / 12*200g |  | 226
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1516 | Sugar 10 KG |  | 64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1516 | Dates For Patient 01Ctn / 3.5Kg |  | 160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1516 | Turkish Coffee |  | 78.86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1516 | Paper Tray Cover |  | 104.34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1590 | [NAME] |  | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1590 | Coffee Mate CTN/12*900g |  | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1590 | Nescafe 01Ctn / 12*200g |  | 188
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1590 | Dates For Patient 01Ctn / 3.5Kg |  | 160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1769 | Red Tea CTN 24/100 |  | 196
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1769 | Nescafe 01Ctn / 12*200g |  | 376
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1769 | Sugar 10 KG |  | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1770 | [NAME] |  | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT-1770 | Turkish Coffee |  | 78.27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total