Link to home
Create AccountLog in
Avatar of morinia
moriniaFlag for United States of America

asked on

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
SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account