SQL Server 2017

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

CREATE TABLE test(
PARENTPART varchar(20),
ParentDescription varchar(15),
Component varchar(15),
Altkey varchar(20),
Qty int,
)

INSERT INTO test
VALUES ('APF.20.015.09','Person Comp','APC2032','000123',1),
('APF.20.015.09','Person Comp','APC2038','000223',1),
('APF.20.015.09','Person Comp','CPC3042','000103',1),
('APF.20.015.09','Person Comp','DPC4032','000124',1),
('APF.20.019.09','Laptop','LPC2039','000123',1),
('APF.20.019.09','Laptop','FPC2034','0001L3',1),
('APF.20.019.09','Laptop','FPC1092','0001K3',1),
('APF.20.019.09','Laptop','CPCL032','0001M3',1);
8 rows affected

select *
from test


PARENTPART
ParentDescription
Component
Altkey
Qty


APF.20.015.09
Person Comp
APC2032
000123
1

APF.20.015.09
Person Comp
APC2038
000223
1

APF.20.015.09
Person Comp
CPC3042
000103
1

APF.20.015.09
Person Comp
DPC4032
000124
1

APF.20.019.09
Laptop
LPC2039
000123
1

APF.20.019.09
Laptop
FPC2034
0001L3
1

APF.20.019.09
Laptop
FPC1092
0001K3
1

APF.20.019.09
Laptop
CPCL032
0001M3
1


select p.parentpart, p.parentdescription,
       c.component, t.altkey, t.qty
from (select distinct parentpart, parentdescription
      from test
     ) p cross join
     (select distinct component
      from test
     ) c left join
     test t
     on t.parentpart = p.parentpart and t.component = c.component
order by parentpart, parentdescription, component;


parentpart
parentdescription
component
altkey
qty


APF.20.015.09
Person Comp
APC2032
000123
1

APF.20.015.09
Person Comp
APC2038
000223
1

APF.20.015.09
Person Comp
CPC3042
000103
1

APF.20.015.09
Person Comp
CPCL032
null
null

APF.20.015.09
Person Comp
DPC4032
000124
1

APF.20.015.09
Person Comp
FPC1092
null
null

APF.20.015.09
Person Comp
FPC2034
null
null

APF.20.015.09
Person Comp
LPC2039
null
null

APF.20.019.09
Laptop
APC2032
null
null

APF.20.019.09
Laptop
APC2038
null
null

APF.20.019.09
Laptop
CPC3042
null
null

APF.20.019.09
Laptop
CPCL032
0001M3
1

APF.20.019.09
Laptop
DPC4032
null
null

APF.20.019.09
Laptop
FPC1092
0001K3
1

APF.20.019.09
Laptop
FPC2034
0001L3
1

APF.20.019.09
Laptop
LPC2039
000123
1

PARENTPART	ParentDescription	Component	Altkey	Qty
APF.20.015.09	Person Comp	APC2032	000123	1
APF.20.015.09	Person Comp	APC2038	000223	1
APF.20.015.09	Person Comp	CPC3042	000103	1
APF.20.015.09	Person Comp	DPC4032	000124	1
APF.20.019.09	Laptop	LPC2039	000123	1
APF.20.019.09	Laptop	FPC2034	0001L3	1
APF.20.019.09	Laptop	FPC1092	0001K3	1
APF.20.019.09	Laptop	CPCL032	0001M3	1