Transposing or moving set of columns into rows
This thread explains how to write T-sql to transpose the columns to rows in sql server
In my database i have a table
I want to transpose the same to the below published result set
EmployeeID Feedback1 Feedback2 Feedback3 Feedback4 Feedback5 Feedback6
1234 feed1 feed2 feed3 feed4 feed5 feed6
Can anyone guide me to derive this using select query in sql server..?