Concatenate duplicates

[maxi0009in]

Hi,

Need help for concatenating duplicate text. Can someone take a look at this data and see if there's a formula that will concatenate as required? I've taken a stab, but it only works where there are 2 notes of the same type etc. but in some cases you'll see there are more than 2, so a cleverer Excel user needs to help me out please!

I need to concatenate the text so it's in one field that can then be use as report; in the attached, I've highlighted where there are notes of the same type for the same date, Type and type 2, that need to be concatenated into one field to.

Thanks,
Maxi

[Bo_Ry]

Excel version lower than 2019 requires a helper column because Textjoin function is not available.

H2 helper
=IF((A2=A3)*(B2=B3)*(D2=D3)*(G2=G3),F2&" "&H3,F2)

I2 result
=IF((A2=A3)*(B2=B3)*(D2=D3)*(G2=G3)*((A2<>A1)+(B2<>B1)+(D2<>D1)+(G2<>G1)),H2,"")

[maxi0009in]

Excel version lower than 2019 requires a helper column because Textjoin function is not available.

Thanks, I am using 2019 version so shall i just directly the formula you have mentioned in I2?

[Bo_Ry]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

Please try at H2

=IF((A2=A3)*(B2=B3)*(D2=D3)*(G2=G3)*((A2<>A1)+(B2<>B1)+(D2<>D1)+(G2<>G1)),TEXTJOIN(" ",,F2:INDEX(F2:F13,MATCH(0,INDEX((A2=A3:A13)*(B2=B3:B13)*(D2=D3:D13)*(G2=G3:G13),),))),"")

[maxi0009in]

Thanks! This work. Appreciate your help.