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...
skhemka Please see the sample workbook. You will have to do the following steps:
1. Save your mark workbooks as .csv files in a specific folder containing only those mark workbooks that you want to combine
2. Save my sample workbook as your workbook then Open Advanced Query Editor and change the folder path in "Source" line to your folder path (note: this is folder path only, not file path)
