Concatenate rows values

Hi everyone,

I have a table in a databse which has job numbers, template nuber, and comments. I have managed to do a bunch or merges, pivots, and joins to get the table to look like this:

You will notice the bulk of the JobNo is the same, this is becasue whenever a new comment is added it creates a duplicate row. What I want to do is join all the comments in to one sell if the JobNo is the same. Can this be done in Query Editor or am I better off using DAX?

Thanks,

Giles