On the cte keep the contactid field and concatened field only

Then you can use the contactid field of the cte to join the update table a