Please see the attached which displays a) the current output and b) the desired output.
The data is looking at a specific question and answers given to the question in an electronic form for three different clients. This particular question is looking at the ethnicity recorded for a client. Each answer is recorded in 4 pieces of data:
Each answer may have multiple instances of the above data (see client_id 202579), but the start and end dates of the categories cannot overlap.
Id like the output to only list open categories and the associated start date and notes, i.e. where there is no end date. Any help with this is appreciated.