Displaying Query Result Vertical Display

[benchpolo]

SELECT a.claimno
	,a.diagrefno
	,a.diag
	,a.diagdesc
	,b.diagrefno as diagrefno2 
	,b.diag as diag2
	,b.diagdesc as diagdesc2
	,c.diagrefno as diagrefno3
	,c.diag as diag3
	,c.diagdesc as diagdesc3
	,d.diagrefno as diagrefno4
	,d.diag as diag4
	,d.diagdesc as diagdesc4
	,e.diagrefno as diagrefno5
	,e.diag as diag5
	,e.diagdesc as diagdesc5

FROM ezcap1.archp.dbo.CLAIM_DIAGS a 
LEFT OUTER JOIN ezcap1.archp.dbo.CLAIM_DIAGS b on a.CLAIMNO=b.CLAIMNO and b.diagrefno = 2
LEFT OUTER JOIN ezcap1.archp.dbo.CLAIM_DIAGS c on a.CLAIMNO=c.CLAIMNO and c.diagrefno = 3
LEFT OUTER JOIN ezcap1.archp.dbo.CLAIM_DIAGS d on a.CLAIMNO=d.CLAIMNO and d.diagrefno = 4
LEFT OUTER JOIN ezcap1.archp.dbo.CLAIM_DIAGS e on a.CLAIMNO=e.CLAIMNO and e.diagrefno = 5
WHERE a.diagrefno = 1

QUESTION
The script above displays data result horizontally. Question? How can I display data vertically?

Thanks.

[Rabbit]

Don't join the table to itself.

[NeoPa]

As Rabbit says, but also sort by [DiagRefNo].