Hello, below screenshots show how initial data are gathered, what i have so far, and what I intend to accomplish.
In second table ("What I updated to so far..." one), Initial Comments and Final Comments are merged and concatenated properly using Join and LookupSet combined. Also, Name, Date, ID, and Type are already added to Row Groups in SQL Data Tools.
However, for Columns Name, Date, and ID, i am attempting to merge them and only have one value present, and I'm having difficulty doing this.
Any help would be great.




