Transposing rows into columns - TSQL Statement
I have a table that has rows for each member as their respective subject and grade. Is there a way I can tranpose these in SQL to put the rows into concatenated columns.
(See attachments)
Rows.xlsx
Columns.xlsx
(See attachments)
Rows.xlsx
Columns.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.