Forum Discussion
Solved
Data help
I need a bit of help with some data I have. We're collecting a set of data each month from 9 schools. The data is always the same but just represents the last 3 months. I have a master excel doc that...
Instead of using different tabs I would recommend to split the data into different Excel files. That will allow Power Query to ingest a list of Excel files from a folder, regardless of how many files are in there.
You can then use additional Power Query transforms to deduplicate the data if needed.
Hi jblackburnHWGA,
Does lbendlin's suggestion help with your requirement? If not, you can also take a look at the following blog about combine multiple sheets in one excel file if it meets your scenario.
Regards,
Xiaoxin Sheng
Hi jblackburnHWGA,
Does lbendlin's suggestion help with your requirement? If not, you can also take a look at the following blog about combine multiple sheets in one excel file if it meets your scenario.
Regards,
Xiaoxin Sheng