UPDATE Sheet1
SET c1 = '1'
WHERE c like '%1%'
UPDATE Sheet1
SET c2 = '1'
WHERE c like '%2%'
UPDATE Sheet1
SET c3 = '3'
WHERE c like '%3%'
UPDATE Sheet1
SET c1 = '1'
WHERE c like '%1%'
UPDATE Sheet1
SET c2 = '1'
WHERE c like '%2%'
UPDATE Sheet1
SET c3 = '3'
WHERE c like '%3%'