대강 만든다면 이런식으로 될 수있을거 같은데여... 2005이상에서요

with t as(
          select '1' A, '1' B, '1' C, '1' D
union all select '2' A, '1' B, '1' C, '*' D
union all select '3' A, '1' B, '*' C, '1' D
union all select '4' A, '1' B, '1' C, '*' D
union all select '5' A, '1' B, '*' C, '*' D
),
dummy AS (
SELECT id = 1
UNION ALL
SELECT id = id + 1 FROM dummy
WHERE id < 4
)
select * from (
select distinct id,
       case id when 1 then case when A = '*' then 'A' end
               when 2 then case when B = '*' then 'B' end
               when 3 then case when C = '*' then 'C' end
               when 4 then case when D = '*' then 'D' end
        end Col
from t, dummy
) t
where col is not null
OPTION (maxrecursion 0)