Hi, I'm guessing there is probably a simple answer if you know how.
I have a table with two fields:
In some instances, the records have been split so I have a number of records with the same reference number, but different CaseNote fragments.
I need to do a one off data clean so that any records with an identical reference number will be merged, leaving a single reference number and a merged CaseNote. For example:
Thanks for your help.