I am trying to generate columns based on the date of the activity.
I used FULL JOIN before but it only generated duplicated rows even when using CASE.
Some guidance on how to approach this would be great.
Table 1 is my current data and Result is the table I am looking for.
