Replace values in a given column (column is comma separated id's) with lookupvalue from a query

How can I replace the values in this first column     With the lookup value from this other query? Ideally it comma separates the values, skipping anything that's null in the lookup (so no bla...