SQL Server 2017

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

CREATE TABLE system(
   CLASS     VARCHAR(11) NOT NULL
  ,CLASSNAME VARCHAR(3) NOT NULL
  ,KEYNAME   VARCHAR(12) NOT NULL
  ,[KEY]       VARCHAR(36) NOT NULL
);
INSERT INTO system(CLASS,CLASSNAME,KEYNAME,[KEY]) VALUES ('11011121600','VMX','#APPLICATION','AF71B74D301842C');
INSERT INTO system(CLASS,CLASSNAME,KEYNAME,[KEY]) VALUES ('11011121600','VMX','#VBOX','BC56379D-B99C-4058-A563-E0CE3D0C1480');
INSERT INTO system(CLASS,CLASSNAME,KEYNAME,[KEY]) VALUES ('A1011121600','VMX','#APPLICATION','AF71B74D301842C');
INSERT INTO system(CLASS,CLASSNAME,KEYNAME,[KEY]) VALUES ('B1011121600','VMX','#VBOX','BC56379D-B99C-4058-A563-E0CE3D0C1480');
INSERT INTO system(CLASS,CLASSNAME,KEYNAME,[KEY]) VALUES ('11011121600','VMX','#xyz','AF71B74D301842C');
5 rows affected

select * from system


CLASS
CLASSNAME
KEYNAME
KEY


11011121600
VMX
#APPLICATION
AF71B74D301842C

11011121600
VMX
#VBOX
BC56379D-B99C-4058-A563-E0CE3D0C1480

A1011121600
VMX
#APPLICATION
AF71B74D301842C

B1011121600
VMX
#VBOX
BC56379D-B99C-4058-A563-E0CE3D0C1480

11011121600
VMX
#xyz
AF71B74D301842C


select
       [CLASS] AS EXTENSION
       
     , max(case when KEYNAME = '#APPLICATION' then [CLASS] end)     as Application
     , max(case when KEYNAME = '#APPLICATION' then [CLASSNAME] end) as ApplicationType
     , max(case when KEYNAME = '#APPLICATION' then [KEY] end)       as ApplicationKey
     
     , max(case when KEYNAME = '#VBOX'        then [CLASS] end)     as Vbox 
     , max(case when KEYNAME = '#VBOX'        then [CLASSNAME] end) as VboxType
     , max(case when KEYNAME = '#VBOX'        then [KEY] end)       as VboxKey
     
     , max(case when KEYNAME = '#xyz'        then [CLASS] end)     as xyz 
     , max(case when KEYNAME = '#xyz'        then [CLASSNAME] end) as xyzType
     , max(case when KEYNAME = '#xyz'        then [KEY] end)       as xyzKey
from [system]
where [keyname] in ('#APPLICATION','#VBOX','#xyz')
group by
       [CLASS] 


EXTENSION
Application
ApplicationType
ApplicationKey
Vbox
VboxType
VboxKey
xyz
xyzType
xyzKey


11011121600
11011121600
VMX
AF71B74D301842C
11011121600
VMX
BC56379D-B99C-4058-A563-E0CE3D0C1480
11011121600
VMX
AF71B74D301842C

A1011121600
A1011121600
VMX
AF71B74D301842C
null
null
null
null
null
null

B1011121600
null
null
null
B1011121600
VMX
BC56379D-B99C-4058-A563-E0CE3D0C1480
null
null
null


Warning: Null value is eliminated by an aggregate or other SET operation.

CLASS	CLASSNAME	KEYNAME	KEY
11011121600	VMX	#APPLICATION	AF71B74D301842C
11011121600	VMX	#VBOX	BC56379D-B99C-4058-A563-E0CE3D0C1480
A1011121600	VMX	#APPLICATION	AF71B74D301842C
B1011121600	VMX	#VBOX	BC56379D-B99C-4058-A563-E0CE3D0C1480
11011121600	VMX	#xyz	AF71B74D301842C