Forum Discussion
Power Query: Get File Name
Hi guys, I am a teacher and I teach different subjects with different assessment types. I want to combine all the marks in a single spreadsheet and then process the grades in one go. I am struggli...
hynguyen Thank you very much for your reply.
But I do not want to combine the other columns. I want to keep Quiz, Assignment, Test and Exam all in separate columns.
I would appreciate your help, please.
Thank you.
skhemka Can you please show what your desired output should look like by manually typing in a sample data with all needed columns? It seems that you want to have a layout like: Source, Student ID, Exam, Quiz, Test, Assignment.
However, like SergeiBaklan mentioned, it is difficult for us to imagine how to treat the case where the same Student ID attends both courses? How do you want to show those cases?