Forum Discussion
Data help
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
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.