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

 |  |  |  |  |  |  | Consumable Report
 | Sr No. |  | CT Number | Site Id |  | Doctor [NAME] |  |  | Transaction Date | Qty | UOM |  |  |  | Base Qty | Base Unit | Price |  | Medical |  | Non Medical | Total Price
 | 9 |  | CT-1111 | [NAME] |  | General- |  |  | 06/03/2023 | 3.00 |  |  |  |  |  |  |  |  | 0.00 |  | 605.5 | 605.5
 |  |  | Non Medical -475 | Nescafe 01Ctn / 12*200g |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 380.00 |  |  |  | 380 | 380
 |  |  | Non Medical -517 | Red Tea CTN 24/100 |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 196.00 |  |  |  | 196 | 196
 |  |  | Non Medical -476 | Sugar 10 KG |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 29.50 |  |  |  | 29.5 | 29.5
 | 13 |  | CT-1244 | [NAME] |  | General- |  |  | 23/03/2023 | 2.00 |  |  |  |  |  |  |  |  | 0.00 |  | 530.43 | 530.43
 |  |  | Non Medical -537 | Cardamom |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 130.43 |  |  |  | 130.43 | 130.43
 |  |  | Non Medical -478 | Coffee Mate CTN/12*900g |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 400.00 |  |  |  | 400 | 400
 | 14 |  | CT-1245 | [NAME] |  | General- |  |  | 23/03/2023 | 5.01 |  |  |  |  |  |  |  |  | 0.00 |  | 758.95 | 758.95
 |  |  | Non Medical -477 | [NAME] |  |  |  |  |  | 3.00 | Piece |  |  |  | 3.00 | PCS | 160.00 |  |  |  | 480 | 480
 |  |  | Non medical -538 | Cloves for Coffee |  |  |  |  |  | 1.01 | Piece |  |  |  | 1.02 | PCS | 52.17 |  |  |  | 52.95 | 52.95
 |  |  | Non Medical -475 | Nescafe 01Ctn / 12*200g |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 226.00 |  |  |  | 226 | 226
 | 15 |  | CT-1516 | [NAME] |  | General- |  |  | 26/04/2023 | 11.00 |  |  |  |  |  |  |  |  | 0.00 |  | 407.2 | 407.2
 |  |  | Non Medical -476 | Sugar 10 KG |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 32.00 |  |  |  | 64 | 64
 |  |  | Non Medical -479 | Dates For Patient 01Ctn / 3.5Kg |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 80.00 |  |  |  | 160 | 160
 |  |  | Non Medical -557 | Turkish Coffee |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 78.86 |  |  |  | 78.86 | 78.86
 |  |  | Non Medical -556 | Paper Tray Cover |  |  |  |  |  | 6.00 | Piece |  |  |  | 6.00 | PCS | 17.39 |  |  |  | 104.34 | 104.34
 | 16 |  | CT-1590 | [NAME] |  | General- |  |  | 09/05/2023 | 8.00 |  |  |  |  |  |  |  |  | 0.00 |  | 1628 | 1628
 |  |  | Non Medical -477 | [NAME] |  |  |  |  |  | 3.00 | Piece |  |  |  | 3.00 | PCS | 160.00 |  |  |  | 480 | 480
 |  |  | Non Medical -478 | Coffee Mate CTN/12*900g |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 400.00 |  |  |  | 800 | 800
 |  |  | Non Medical -475 | Nescafe 01Ctn / 12*200g |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 188.00 |  |  |  | 188 | 188
 |  |  | Non Medical -479 | Dates For Patient 01Ctn / 3.5Kg |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 80.00 |  |  |  | 160 | 160
 | 19 |  | CT-1769 | [NAME] |  | General- |  |  | 30/05/2023 | 6.00 |  |  |  |  |  |  |  |  | 0.00 |  | 668 | 668
 |  |  | Non Medical -517 | Red Tea CTN 24/100 |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 196.00 |  |  |  | 196 | 196
 |  |  | Non Medical -475 | Nescafe 01Ctn / 12*200g |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 188.00 |  |  |  | 376 | 376
 |  |  | Non Medical -476 | Sugar 10 KG |  |  |  |  |  | 3.00 | Piece |  |  |  | 3.00 | PCS | 32.00 |  |  |  | 96 | 96
 | 20 |  | CT-1770 | [NAME] |  | General- |  |  | 30/05/2023 | 6.00 |  |  |  |  |  |  |  |  | 0.00 |  | 558.27 | 558.27
 |  |  | Non Medical -477 | [NAME] |  |  |  |  |  | 3.00 | Piece |  |  |  | 3.00 | PCS | 160.00 |  |  |  | 480 | 480
 |  |  | Non Medical -557 | Turkish Coffee |  |  |  |  |  | 3.00 | Piece |  |  |  | 3.00 | PCS | 26.09 |  |  |  | 78.27 | 78.27
 |  |  |  |  |  |  |  |  | Total | 1529.02 |  |  |  |  |  |  |  |  | 0.00 |  | 27019.83 | 27019.83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total