SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mytable (ProductId int, GroupId int)
insert into mytable
values
(100,1),
(100,2),
(200,1),
(200,2),
(200,4),
(200,5)
6 rows affected

select * from mytable


ProductId
GroupId


100
1

100
2

200
1

200
2

200
4

200
5


select
   ProductId
   ,IsGroup1 = iif([1] is null,0,1)
   ,IsGroup2 = iif([2] is null,0,1)
   ,IsGroup3 = iif([3] is null,0,1)
   ,IsGroup4 = iif([4] is null,0,1)
   ,IsGroup5 = iif([5] is null,0,1)
from
(select ProductID, GroupId from mytable) x
pivot
(max(GroupId) for GroupId in ([1],[2],[3],[4],[5])) p


ProductId
IsGroup1
IsGroup2
IsGroup3
IsGroup4
IsGroup5


100
1
1
0
0
0

200
1
1
0
1
1