Spreadsheet: 873527d1720018019-extract-employee-codes-defects-and-dates-specific-length-and-code-sample
Sheet: Sheet1

Data I Have |  |  |  |  |  |  | Result I need please
Date | [NAME] report | Line# | Type of Defects | Number of Defects | Chechker Name |  | Card | Defects | 2024-06-01 00:00:00 | 2024-06-03 00:00:00 | 2024-06-05 00:00:00 | 2024-06-12 00:00:00 | 2024-06-13 00:00:00 | Total
2024-06-01 00:00:00 | 7 | M10Assesmbly2 | 07 Needle Chew Mark | 3 | anum |  | 10000001 | T08 Total Red Points | 1 | 1 |  | 1
2024-06-01 00:00:00 | 7 | M10Assesmbly2 | 27 Total Defectives Pcs | 4 | anum |  | 10000001 | T09 Total Yellow Points |  |  |  | 1 | 1
2024-06-01 00:00:00 | 7 | M10Assesmbly2 | 27 Total Defectives Pcs | 5 | anum |  | 10000003 | T08 Total Red Points |  | 2
2024-06-01 00:00:00 | 7 | M10Assesmbly2 | 28 Total Pcs Checked | 24 | anum |  | 10000003 | T09 Total Yellow Points |  |  | 1
2024-06-01 00:00:00 | 7 | M10Assesmbly2 | 28 Total Pcs Checked | 25 | anum |  | 10000002 | T08 Total Red Points |  | 1 | 1
2024-06-01 00:00:00 | 8 | M10Assesmbly2 | T01 Operator Card Number | 10000001 | shakeel akhtar |  | 10000002 | T09 Total Yellow Points
2024-06-01 00:00:00 | 8 | M10Assesmbly2 | T06 Workmanship | 2 | shakeel akhtar |  | 10000004 | T08 Total Red Points |  |  | 4
2024-06-01 00:00:00 | 8 | M10Assesmbly2 | T08 Total Red Points | 1 | shakeel akhtar |  | 10000004 | T09 Total Yellow Points
2024-06-01 00:00:00 | 8 | M10Assesmbly2 | T10 Total pcs Checked | 5 | shakeel akhtar
2024-06-01 00:00:00 | 8 | M10Assesmbly2 | T11 Total Defective | 2 | shakeel akhtar
2024-06-01 00:00:00 | 8 | [NAME] | 01 Broken stitch | 1 | rafia |  | Custom | Type of Defects | 6/1/2024 | 6/3/2024 | 6/5/2024 | 6/12/2024 | 6/13/2024
2024-06-01 00:00:00 | 8 | [NAME] | 10 Wrong Operation | 2 | rafia |  | 10000001 | T08 Total Red Points | 1 | 1 |  | 1
2024-06-01 00:00:00 | 8 | [NAME] | 14 Raw/ frying edges | 1 | rafia |  | 10000001 | T09 Total Yellow Points |  |  |  | 1 | 1
2024-06-01 00:00:00 | 8 | [NAME] | 26 Missing bar tack | 3 | rafia |  | 10000002 | T08 Total Red Points |  | 1 | 1
2024-06-01 00:00:00 | 8 | [NAME] | 27 Total Defectives Pcs | 2 | rafia |  | 10000003 | T08 Total Red Points |  | 2 | 1
2024-06-01 00:00:00 | 8 | [NAME] | 27 Total Defectives Pcs | 3 | rafia |  | 10000004 | T08 Total Red Points |  |  | 4
2024-06-01 00:00:00 | 8 | [NAME] | 28 Total Pcs Checked | 43 | rafia
2024-06-01 00:00:00 | 8 | [NAME] | 28 Total Pcs Checked | 52 | rafia
2024-06-03 00:00:00 | 8 | M2Assesmbly2 | T01 Operator Card Number | 10000003 | naseem akhter
2024-06-03 00:00:00 | 8 | M2Assesmbly2 | T02 Missing Operation | 1 | naseem akhter
2024-06-03 00:00:00 | 8 | M2Assesmbly2 | T08 Total Red Points | 2 | naseem akhter
2024-06-03 00:00:00 | 8 | M2Assesmbly2 | T10 Total pcs Checked | 5 | naseem akhter
2024-06-03 00:00:00 | 8 | M2Assesmbly2 | T11 Total Defective | 1 | naseem akhter
2024-06-03 00:00:00 | 8 | M2Assesmbly2 | 01 Broken stitch | 2 | shan
2024-06-03 00:00:00 | 8 | M2Assesmbly2 | 06 Roping and Puckering | 1 | shan
2024-06-03 00:00:00 | 8 | M2Assesmbly2 | 27 Total Defectives Pcs | 3 | shan
2024-06-03 00:00:00 | 8 | M2Assesmbly2 | 28 Total Pcs Checked | 50 | shan
2024-06-03 00:00:00 | 8 | [NAME] | 02 Skip Stitch | 1 | rafia
2024-06-03 00:00:00 | 8 | [NAME] | 03 Slip Stitches | 2 | rafia
2024-06-03 00:00:00 | 8 | [NAME] | 05 poor joint stitches | 2 | rafia
2024-06-03 00:00:00 | 8 | [NAME] | 27 Total Defectives Pcs | 2 | rafia
2024-06-03 00:00:00 | 8 | [NAME] | 27 Total Defectives Pcs | 4 | rafia
2024-06-03 00:00:00 | 8 | [NAME] | 28 Total Pcs Checked | 32 | rafia
2024-06-03 00:00:00 | 8 | [NAME] | 28 Total Pcs Checked | 42 | rafia
2024-06-03 00:00:00 | 8 | [NAME] | 28 Total Pcs Checked | 54 | rafia
2024-06-03 00:00:00 | 8 | M8Front | T01 Operator Card Number | 10000002 | [NAME]
2024-06-03 00:00:00 | 8 | M8Front | [NAME] | 2 | [NAME]
2024-06-03 00:00:00 | 8 | M8Front | T08 Total Red Points | 1 | [NAME]
2024-06-03 00:00:00 | 8 | M8Front | T10 Total pcs Checked | 5 | [NAME]
2024-06-03 00:00:00 | 8 | M8Front | T11 Total Defective | 1 | [NAME]
2024-06-03 00:00:00 | 8 | N1Assesmbly2 | 03 Slip Stitches | 4 | shaghufta
2024-06-03 00:00:00 | 8 | N1Assesmbly2 | 14 Raw/ frying edges | 3 | shaghufta
2024-06-03 00:00:00 | 8 | N1Assesmbly2 | 27 Total Defectives Pcs | 6 | shaghufta
2024-06-03 00:00:00 | 8 | N1Assesmbly2 | 28 Total Pcs Checked | 35 | shaghufta
2024-06-03 00:00:00 | 9 | M10AssemblyInside | T01 Operator Card Number | 10000001 | shakeel akhtar
2024-06-03 00:00:00 | 9 | M10AssemblyInside | T06 Workmanship | 2 | shakeel akhtar
2024-06-03 00:00:00 | 9 | M10AssemblyInside | T08 Total Red Points | 1 | shakeel akhtar
2024-06-03 00:00:00 | 9 | M10AssemblyInside | T10 Total pcs Checked | 5 | shakeel akhtar
2024-06-03 00:00:00 | 9 | M10AssemblyInside | T11 Total Defective | 2 | shakeel akhtar
2024-06-03 00:00:00 | 9 | M10Assesmbly2 | 03 Slip Stitches | 2 | anum
2024-06-03 00:00:00 | 9 | M10Assesmbly2 | 05 poor joint stitches | 3 | anum
2024-06-03 00:00:00 | 9 | M10Assesmbly2 | 07 Needle Chew Mark | 1 | anum
2024-06-03 00:00:00 | 9 | M10Assesmbly2 | 26 Missing bar tack | 3 | anum
2024-06-03 00:00:00 | 9 | M10Assesmbly2 | 27 Total Defectives Pcs | 5 | anum
2024-06-03 00:00:00 | 9 | M10Assesmbly2 | 28 Total Pcs Checked | 25 | anum
2024-06-05 00:00:00 | 7 | [NAME] | 27 Total Defectives Pcs | 4 | fouzia
2024-06-05 00:00:00 | 7 | [NAME] | 27 Total Defectives Pcs | 5 | fouzia
2024-06-05 00:00:00 | 7 | [NAME] | 28 Total Pcs Checked | 50 | fouzia
2024-06-05 00:00:00 | 7 | [NAME] | 28 Total Pcs Checked | 60 | fouzia
2024-06-05 00:00:00 | 7 | [NAME] | 29 Total Machine inline | 65 | fouzia
2024-06-05 00:00:00 | 8 | M10Assesmbly2 | 01 Broken stitch | 2 | anum
2024-06-05 00:00:00 | 8 | M10Assesmbly2 | 26 Missing bar tack | 4 | anum
2024-06-05 00:00:00 | 8 | M10Assesmbly2 | 27 Total Defectives Pcs | 4 | anum
2024-06-05 00:00:00 | 8 | M10Assesmbly2 | 28 Total Pcs Checked | 54 | anum
2024-06-05 00:00:00 | 8 | [NAME] | T01 Operator Card Number | 10000004 | [NAME]
2024-06-05 00:00:00 | 8 | [NAME] | T02 Missing Operation | 2 | [NAME]
2024-06-05 00:00:00 | 8 | [NAME] | T08 Total Red Points | 4 | [NAME]
2024-06-05 00:00:00 | 8 | [NAME] | T10 Total pcs Checked | 5 | [NAME]
2024-06-05 00:00:00 | 8 | [NAME] | T11 Total Defective | 2 | [NAME]
2024-06-05 00:00:00 | 8 | M8Front | T01 Operator Card Number | 10000002 | [NAME]
2024-06-05 00:00:00 | 8 | M8Front | [NAME] | 2 | [NAME]
2024-06-05 00:00:00 | 8 | M8Front | T08 Total Red Points | 1 | [NAME]
2024-06-05 00:00:00 | 8 | M8Front | T10 Total pcs Checked | 5 | [NAME]
2024-06-05 00:00:00 | 8 | M8Front | T11 Total Defective | 1 | [NAME]
2024-06-05 00:00:00 | 8 | N1Assesmbly2 | 03 Slip Stitches | 2 | shaghufta
2024-06-05 00:00:00 | 8 | N1Assesmbly2 | 11 Missing Operation | 1 | shaghufta
2024-06-05 00:00:00 | 8 | N1Assesmbly2 | 14 Raw/ frying edges | 4 | shaghufta
2024-06-05 00:00:00 | 8 | N1Assesmbly2 | 27 Total Defectives Pcs | 6 | shaghufta
2024-06-05 00:00:00 | 8 | N1Assesmbly2 | 28 Total Pcs Checked | 30 | shaghufta
2024-06-05 00:00:00 | 9 | M10Assesmbly2 | 05 poor joint stitches | 3 | anum
2024-06-05 00:00:00 | 9 | M10Assesmbly2 | 11 Missing Operation | 3 | anum
2024-06-05 00:00:00 | 9 | M10Assesmbly2 | 27 Total Defectives Pcs | 5 | anum
2024-06-05 00:00:00 | 9 | M10Assesmbly2 | 28 Total Pcs Checked | 55 | anum
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | T01 Operator Card Number | 10000003 | naseem akhter
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | T06 Workmanship | 1 | naseem akhter
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | T08 Total Red Points | 1 | naseem akhter
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | T10 Total pcs Checked | 5 | naseem akhter
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | T11 Total Defective | 1 | naseem akhter
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | 01 Broken stitch | 1 | shan
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | 01 Broken stitch | 7 | shan
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | 03 Slip Stitches | 2 | shan
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | 27 Total Defectives Pcs | 3 | shan
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | 27 Total Defectives Pcs | 7 | shan
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | 28 Total Pcs Checked | 30 | shan
2024-06-05 00:00:00 | 9 | M2Assesmbly2 | 28 Total Pcs Checked | 30 | shan
2024-06-12 00:00:00 | 5 | M10AssemblyInside | T01 Operator Card Number | 10000001 | shakeel akhtar
2024-06-12 00:00:00 | 5 | M10AssemblyInside | T02 Missing Operation | 1 | shakeel akhtar
2024-06-12 00:00:00 | 5 | M10AssemblyInside | [NAME] | 1 | shakeel akhtar
2024-06-12 00:00:00 | 5 | M10AssemblyInside | T06 Workmanship | 2 | shakeel akhtar
2024-06-12 00:00:00 | 5 | M10AssemblyInside | T08 Total Red Points | 1 | shakeel akhtar
2024-06-12 00:00:00 | 5 | M10AssemblyInside | T09 Total Yellow Points | 1 | shakeel akhtar
2024-06-12 00:00:00 | 5 | M10AssemblyInside | T10 Total pcs Checked | 5 | shakeel akhtar
2024-06-12 00:00:00 | 5 | M10AssemblyInside | T10 Total pcs Checked | 5 | shakeel akhtar
2024-06-13 00:00:00 | 5 | M10AssemblyInside | T01 Operator Card Number | 10000001 | shakeel akhtar
2024-06-13 00:00:00 | 5 | M10AssemblyInside | T02 Missing Operation | 1 | shakeel akhtar
2024-06-13 00:00:00 | 5 | M10AssemblyInside | [NAME] | 1 | shakeel akhtar
2024-06-13 00:00:00 | 5 | M10AssemblyInside | T06 Workmanship | 2 | shakeel akhtar
2024-06-13 00:00:00 | 5 | M10AssemblyInside | T09 Total Yellow Points | 1 | shakeel akhtar
2024-06-13 00:00:00 | 5 | M10AssemblyInside | T10 Total pcs Checked | 5 | shakeel akhtar
2024-06-13 00:00:00 | 5 | M10AssemblyInside | T10 Total pcs Checked | 5 | shakeel akhtar