Q&A for biology researchers, academics, and students
CREATE TABLE #yt ([fm] nvarchar (100) , [fp] nvarchar (100), [fr] int) ; INSERT INTO #yt ([fm], [fp], [fr]) VALUES ('ERR', 'CLB', 56), ('PLA', 'TO', 138), ('ERR', 'LDG', 37), ('PLA', 'CRZ', 59), ('PLU', 'CRZ', 282), ('TLA', 'DES', 212), ('ERR', 'DES', 78), ('PLU', 'APP', 97), ('ERR', 'CLB', 60), ('PLU', 'LDG', 123), ('TLA', 'APP', 220), ('TLA', 'GND', 87) ; select * from ( select fm, fp, fr from #yt ) src pivot ( MAX(fr) for fp in ([APP], [CLB], [CRZ], [DES], [GND], [LDG], [TO]) ) AS piv ;