如何确定COALESCE运算符成功选择的列/值？

I have a table that I wish to find the first non-null value from 3 (and only 3) columns for each ID starting with Col1 then to Col2 then to Col3I have a table that I wish to find the first no