COLLECT – IF – DISTINCT Challenge
I want to JOIN(COLLECT) unique, distinct instances of a date given values in other columns. I have a history log of participant registration dates. The participant can register more than one time on a given date. I want to JOIN(COLLECT) all of the unique registration dates an individual registers. Is this possible?
Table 1 has what I already have – a history of all registration instances. Table 2 is a separate table, where I want the data collected (red text is what I’m missing). Thoughts?