Transform Table via Query

[TheGomzee]

Hi Good day, I am seeking help in the area of Power Query.

I have a database for students' marks in a table. The rows are individual students and the columns are mainly the subjects that they study as seen below.

I would like to transform this table automatically via Query whereby each row would be a student and their mark for a subject.



Attachment 780638

[Bo_Ry]

Maybe try

Please Login or Register  to view this content.

[TheGomzee]

Thank you very much. It works perfectly.