Spreadsheet: 766458d1643899482-single-cell-formula-with-let-and-unique-and-text-join-to-summarize-a-data-return-a-unique-textjoin-results
Sheet: Sheet1

expected result
Item Code | Item Description | Month | Delivery no | Purpose of use | Hired qty | off Hired qty | Balance qty |  | Month | Delivery no | Item Code | Item Description | Purpose of use | Hired qty | off Hired qty
77127862 | Acrow Beam S12 L=2.50m | Jul-20 | Aug-20 | Jul-20 | Nov-20 | 2007/2897 | 2007/2969 | 2007/2969 | 2007/2969 | Shoring Sofit-Pier Head 11 | For Enternal/Span-3 | For Shoring/Span-3 | Material for External/Span-3 | 552 | 485 |  |  | [NAME] | 2007/2897 | 77127862 | Acrow Beam S12 L=2.50m | Shoring Sofit-Pier Head 11 | 125
77141684 | Soldier-S12 Connection (S) | Aug-20 | Sep-20 | 2007/2897 | 2007/2969 | For Shoring/Span-03 | 244 | 219 |  |  | Aug-20 | 2007/2897 | 77141684 | Soldier-S12 Connection (S) | For Shoring/Span-03 | 127
77022242 | Splice 60cm Double | Sep-20 | Nov-20 | 2007/2897 | 2007/2969 | For Span 1 | For Shoring Gantry-B | 226 | 201 |  |  | Sep-20 | 2007/2897 | 77022242 | Splice 60cm Double | For Span 1 | 129
77132101 | Acrow Beam S12 L=2.0m | Oct-20 | 2007/2897 | For Shoring Span-1 | 131 | 121 |  |  | Oct-20 | 2007/2897 | 77132101 | Acrow Beam S12 L=2.0m | For Shoring Span-1 | 131
77134440 | Acrow Beam S12 L=3.50m | Nov-20 | 2007/2897 | For External Span-3 | 133 | 123 |  |  | Nov-20 | 2007/2897 | 77134440 | Acrow Beam S12 L=3.50m | For External Span-3 | 133
77115135 | Soldier U100 L=2.25m | May-21 | [NAME] | Aug-20 | 2007/2897 | 2007/2897 | 2007/2946 | For External Span-1 | For Shoring Span-3 | For Pier Head 12 Sofit | 399 | 359 |  |  | May-21 | 2007/2897 | 77115135 | Soldier U100 L=2.25m | For External Span-1 | 135
77138226 | Soldier to Strong-Back Connector | Oct-20 | 2007/2969 | For Shoring Span-2 | 107 | 92 |  |  | [NAME] | 2007/2897 | 77115135 | Soldier U100 L=2.25m | For Shoring Span-3 | 137
77026042 | Universal Corner Angle Tie Holes | May-21 | 2007/2969 | For Span 3 | 87 | 72 |  |  | Aug-20 | 2007/2946 | 77115135 | Soldier U100 L=2.25m | For [NAME] 12 Sofit | 127
77012304 | [NAME] 17mm L=12.5cm (Type I) | [NAME] | 2007/2969 | Material for Shoring for Gantry-B | 77 | 62 |  |  | Sep-20 | 2007/2969 | 77141684 | Soldier-S12 Connection (S) |  | 117
77014261 | Push Pull PPS132 | Sep-20 | 2007/2969 | For Shoring/Span-4 | 57 | 42 |  |  | Oct-20 | 2007/2969 | 77138226 | Soldier to Strong-Back Connector | For Shoring Span-2 | 107
77014308 | Push Pull PPS202 | Oct-20 | 2007/2969 | For Enternal/Span-1 | 47 | 32 |  |  | Nov-20 | 2007/2969 | 77022242 | Splice 60cm Double | For Shoring Gantry-B | 97
77009366 | Shore Brace Frame (H) | Nov-20 | 2007/2969 | For Enternal/Span-2 | 37 | 22 |  |  | May-21 | 2007/2969 | 77026042 | Universal Corner Angle Tie Holes | For Span 3 | 87
77011185 | Link Spacer 60cm (O) | May-21 | Oct-20 | 2007/2969 | 2007/2969 | For Enternal/Span-4 | Material for External/Span-2 | 258 | 222 |  |  | [NAME] | 2007/2969 | 77012304 | [NAME] 17mm L=12.5cm (Type I) | Material for Shoring for Gantry-B | 77
77011161 | [NAME] 30cm (O) | Aug-20 | 2007/2969 | Material For Shoring/Span-4 | 129 | 108 |  |  | Aug-20 | 2007/2969 | 77127862 | Acrow Beam S12 L=2.50m | For Enternal/Span-3 | 67
77011178 | [NAME] (O) | Sep-20 | 2007/2969 | Material for External/Span-1 | 180 | 159 |  |  | Sep-20 | 2007/2969 | 77014261 | Push Pull PPS132 | For Shoring/Span-4 | 57
77141523 | Cross Brace 1.20m | May-21 | 2007/2969 | Material for External/Span-4 | 333 | 312 |  |  | Oct-20 | 2007/2969 | 77014308 | Push Pull PPS202 | For Enternal/Span-1 | 47
 |  |  |  | Totals |  |  |  |  | Nov-20 | 2007/2969 | 77009366 | Shore Brace Frame (H) | For Enternal/Span-2 | 37
 |  |  |  |  |  |  |  |  | May-21 | 2007/2969 | 77011185 | Link Spacer 60cm (O) | For Enternal/Span-4 | 27
 |  |  |  |  |  |  |  |  | [NAME] | 2007/2969 | 77127862 | Acrow Beam S12 L=2.50m | For Shoring/Span-3 | 78
 |  |  |  |  |  |  |  |  | Aug-20 | 2007/2969 | 77011161 | [NAME] 30cm (O) | Material For Shoring/Span-4 | 129
 | Acrow Beam S12 L=2.50m | Jul-20 | Aug-20 | Jul-20 | Nov-20 | 2007/2897 | 2007/2969 | 2007/2969 | 2007/2969 | Shoring Sofit-Pier Head 11 | For Enternal/Span-3 | For Shoring/Span-3 | Material for External/Span-3 | 552 | 485 | 67 |  | Sep-20 | 2007/2969 | 77011178 | [NAME] (O) | Material for External/Span-1 | 180
77141684 | Soldier-S12 Connection (S) | Aug-20 | Sep-20 | 2007/2897 | 2007/2969 | For Shoring/Span-03 | 244 | 219 | 25 |  | Oct-20 | 2007/2969 | 77011185 | Link Spacer 60cm (O) | Material for External/Span-2 | 231
77022242 | Splice 60cm Double | Sep-20 | Nov-20 | 2007/2897 | 2007/2969 | For Span 1 | For Shoring Gantry-B | 226 | 201 | 25 |  | Nov-20 | 2007/2969 | 77127862 | Acrow Beam S12 L=2.50m | Material for External/Span-3 | 282
77132101 | Acrow Beam S12 L=2.0m | Oct-20 | 2007/2897 | For Shoring Span-1 | 131 | 121 | 10 |  | May-21 | 2007/2969 | 77141523 | Cross Brace 1.20m | Material for External/Span-4 | 333
77134440 | Acrow Beam S12 L=3.50m | Nov-20 | 2007/2897 | For External Span-3 | 133 | 123 | 10
77115135 | Soldier U100 L=2.25m | May-21 | [NAME] | Aug-20 | 2007/2897 | 2007/2897 | 2007/2946 | For External Span-1 | For Shoring Span-3 | For Pier Head 12 Sofit | 399 | 359 | 40
77138226 | Soldier to Strong-Back Connector | Oct-20 | 2007/2969 | For Shoring Span-2 | 107 | 92 | 15
77026042 | Universal Corner Angle Tie Holes | May-21 | 2007/2969 | For Span 3 | 87 | 72 | 15
77012304 | [NAME] 17mm L=12.5cm (Type I) | [NAME] | 2007/2969 | Material for Shoring for Gantry-B | 77 | 62 | 15
77014261 | Push Pull PPS132 | Sep-20 | 2007/2969 | For Shoring/Span-4 | 57 | 42 | 15
77014308 | Push Pull PPS202 | Oct-20 | 2007/2969 | For Enternal/Span-1 | 47 | 32 | 15
77009366 | Shore Brace Frame (H) | Nov-20 | 2007/2969 | For Enternal/Span-2 | 37 | 22 | 15
77011185 | Link Spacer 60cm (O) | May-21 | Oct-20 | 2007/2969 | 2007/2969 | For Enternal/Span-4 | Material for External/Span-2 | 258 | 222 | 36
77011161 | [NAME] 30cm (O) | Aug-20 | 2007/2969 | Material For Shoring/Span-4 | 129 | 108 | 21
77011178 | [NAME] (O) | Sep-20 | 2007/2969 | Material for External/Span-1 | 180 | 159 | 21
77141523 | Cross Brace 1.20m | May-21 | 2007/2969 | Material for External/Span-4 | 333 | 312 | 21
 |  |  |  | Totals | 2997 | 2631 | 366
 | Acrow Beam S12 L=2.50m | Jul-20 | Aug-20 | Jul-20 | Nov-20 | 2007/2897 | 2007/2969 | 2007/2969 | 2007/2969 | Shoring Sofit-Pier Head 11 | For Enternal/Span-3 | For Shoring/Span-3 | Material for External/Span-3 | 552 | 485 | 67
77141684 | Soldier-S12 Connection (S) | Aug-20 | Sep-20 | 2007/2897 | 2007/2969 | For Shoring/Span-03 | 244 | 219 | 25
77022242 | Splice 60cm Double | Sep-20 | Nov-20 | 2007/2897 | 2007/2969 | For Span 1 | For Shoring Gantry-B | 226 | 201 | 25
77132101 | Acrow Beam S12 L=2.0m | Oct-20 | 2007/2897 | For Shoring Span-1 | 131 | 121 | 10
77134440 | Acrow Beam S12 L=3.50m | Nov-20 | 2007/2897 | For External Span-3 | 133 | 123 | 10
77115135 | Soldier U100 L=2.25m | May-21 | [NAME] | Aug-20 | 2007/2897 | 2007/2897 | 2007/2946 | For External Span-1 | For Shoring Span-3 | For Pier Head 12 Sofit | 399 | 359 | 40
77138226 | Soldier to Strong-Back Connector | Oct-20 | 2007/2969 | For Shoring Span-2 | 107 | 92 | 15
77026042 | Universal Corner Angle Tie Holes | May-21 | 2007/2969 | For Span 3 | 87 | 72 | 15
77012304 | [NAME] 17mm L=12.5cm (Type I) | [NAME] | 2007/2969 | Material for Shoring for Gantry-B | 77 | 62 | 15
77014261 | Push Pull PPS132 | Sep-20 | 2007/2969 | For Shoring/Span-4 | 57 | 42 | 15
77014308 | Push Pull PPS202 | Oct-20 | 2007/2969 | For Enternal/Span-1 | 47 | 32 | 15
77009366 | Shore Brace Frame (H) | Nov-20 | 2007/2969 | For Enternal/Span-2 | 37 | 22 | 15
77011185 | Link Spacer 60cm (O) | May-21 | Oct-20 | 2007/2969 | 2007/2969 | For Enternal/Span-4 | Material for External/Span-2 | 258 | 222 | 36
77011161 | [NAME] 30cm (O) | Aug-20 | 2007/2969 | Material For Shoring/Span-4 | 129 | 108 | 21
77011178 | [NAME] (O) | Sep-20 | 2007/2969 | Material for External/Span-1 | 180 | 159 | 21
77141523 | Cross Brace 1.20m | May-21 | 2007/2969 | Material for External/Span-4 | 333 | 312 | 21
 |  |  |  | Totals | 2997 | 2631 | 366