How to create 3 columns from 2 columns with SQL query?
You need to use a pivot table to get colums out of rows for what you're after

select speed, idp.[1] as power600V,idp.[2] as power750V
from tableName PIVOT
(
MAX(power)
FOR id in([1],[2])
) as idp


will get you the results you're after

https://technet.microsoft.com/en-us/library/ms177410 for the full pivot reference