100分向搞手求助SQL數據報表中數據由縱向轉為橫向問題!

SN          keypart_name keyPart_sn
TRAVEL1233 POWER_BD          POWER2
TRAVEL1233 CONTRO_BD     CONTRO32
TRAVEL1233 FIF_BD          FIF_BD2
TRAVEL1233 FILTER_BD          FILTER32
TRAVEL1234 POWER_BD          POWER3
TRAVEL1234 CONTRO_BD       CONTRO33
TRAVEL1234 FIF_BD          FIF_BD3
TRAVEL1234 FILTER_BD      FILTER33
數據轉為：
SN         POWER_BD CONTRO_BD  FIF_BD FILTER_BD
TRAVEL1233 POWER2 CONTRO32  FIF_BD2 FILTER32
TRAVEL1234 POWER3 CONTRO33  FIF_BD3 FILTER33