SQL Server 2017

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

XTypeNo	Xtype	Xvalue	Xmin	Xmax
1	TypeA	10	100	200
2	TypeA	20	100	200
3	TypeA	30	100	200
4	TypeB	410	200	300
5	TypeB	420	200	300
6	TypeB	430	200	300
7	TypeC	310	300	400
8	TypeC	320	300	400
9	TypeC	330	300	400
12	TypeD	410	400	500
13	TypeD	490	400	500
14	TypeD	550	400	500
15	TypeE	510	500	600
16	TypeE	590	500	600
17	TypeE	450	500	600
18	TypeD	505	400	500
19	TypeD	506	400	500
20	TypeF	590	500	600
21	TypeF	450	500	600
22	TypeG	450	600	700
23	TypeG	460	600	700
24	TypeG	470	600	700
25	TypeG	650	600	700
26	TypeG	660	600	700
27	TypeG	850	600	700
28	TypeG	860	600	700
29	TypeG	870	600	700
30	TypeH	null	null	null

Xtype	X1	X2	X3	XGROUP_NEW
TypeA	3	0	0	X1
TypeB	0	0	3	X3
TypeC	0	3	0	X2
TypeD	0	2	3	X3
TypeE	1	2	0	X1
TypeF	1	1	0	X1
TypeG	3	2	3	X3
TypeH	0	0	0	null