Forum Discussion

Copper Contributor

May 31, 2020

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...

Accounting 201.xlsx9 KB

Accounting 101.xlsx9 KB

excel

Formulas and Functions

skhemka

Copper Contributor

Jun 01, 2020

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

Copper Contributor

Jun 01, 2020

hynguyen Dear hynguyen, please find attached what I have done.n As you can see, the "assignment" and the "test" columns are missing for the second spreadsheet. Any help will be greatly appreciated. Thank you.

skhemka Merged File.xlsx20 KB