VZ2Wire       DSLAMGLite
Krone/Port    Unit/Slot/Port
  1-2            1-6-2

type	        unit	krone	slot	port
VZ2Wire	        NULL	1	NULL	2
DSLAMGLite	1	NULL	6	2

SELECT p.type, unit,krone,slot,port
FROM PTDbCircuits c
	inner join PTDbPairs p
		on c.trackid = p.FinLineId
	inner join PTDbTrackRef t
		on c.trackid = t.trackid

declare @t table
(
type	varchar(30),
unit int,
krone int,
slot int,
port int
)
insert @t
values('VZ2Wire',        NULL,	1,	NULL,	2),
('DSLAMGLite',	1,	NULL,	6,	2)

;With CTE
AS
(
select *
from @t
unpivot (val for cat in (unit,krone,slot,port))u
)
select [DSLAMGLite],[VZ2Wire]
from
(
select TYPE,
STUFF((SELECT '/' + cat from CTE where TYPE = c1.TYPE FOR XML PATH('')),1,1,'') AS cats,
1 AS ItemOrd
from (select distinct TYPE from CTE)c1
UNION ALL
select TYPE,
STUFF((SELECT '-' + CAST(val as varchar(10)) from CTE where TYPE = c1.TYPE FOR XML PATH('')),1,1,'') AS vals,
2
from (select distinct TYPE from CTE)c1
)m
PIVOT (MAX(cats) FOR TYPE IN ([DSLAMGLite],[VZ2Wire]))p


output
----------------------------------------
DSLAMGLite	VZ2Wire
----------------------------------------
unit/slot/port	krone/port
1-6-2	        1-2