Please see the attached displaying - 1. the current table data and - 2. the desired output.
This data is looking at clients, assessments undertaken on them, and answers given in these assessments.
If a clients set of answers is replicated on another clients answers, I'd like the set of answers to only appear once and the clients numbers to be listed.
in this example, the question is asking about the clients ethnicity - there are 4 separate answers to the question - START_DATE, END_DATE, CAT_DESC and NOTES. As you can see in the answers given for clients 147 and 8456 in the AVD_DATA (answers column) matches so the clients answers only appear once.
I'm not sure if this is possible. Any help is appreciated.