What about the table you mention in your first post? I thought that was the table being updated?
Looks to me like you are changing your requirements and I still don't see any expected results based on sample data after the update(s) are completed.
@Lynn: The requirements didn't really change.
I've asked the OP to post the "source table" where the comma separated list is derived from.
So, it's "my fault" 😉