Forum Discussion
Row into columns for value
Hi, i have this data: i have 4 rows for the same WTPARTNUMBER, the only different value is the column "MDP_PLM_Superse" I want to transoform this into 1 row and X new colum...
Hi Anonymous ,
Can this help?
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In SQL Server you can use the PIVOT function to transform the data from rows to columns: select Firstname, Amount, PostalCode, LastName, AccountNumber from ( select value, columnname from yourtable ) d pivot ( max(value) for columnname in (Firstname, Amount, PostalCode, LastName, AccountNumber) ) piv;