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
Bookmarks