Related Posts
Does kpmg sponsor KPMG
Additional Posts in Excel Genius
Anyone know what these badges are?

New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Does kpmg sponsor KPMG
Anyone know what these badges are?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

Power query if you’re combining similar data from multiple files.
This is the right answer!
Power query if you only have access to excel. It would be worth dropping it into the premium version of Claude.ai or ChatGPT and asking it to consolidate for you. I don’t think GPT does file creation yet, but Claude definitely does. Just give it clear instructions and it might be faster than you learning power query.
HOWEVER, depending on the data you have you may not want to put it into those AI systems. If it has personal information of students all that information gets stored in their databases. But you could replace personal info with fake names that you can map back maybe. Hope that’s helpful
Thank you!
What’s your end goal/ usage?
Power Query
You'll need to Google a few bits but from the Excel ribbon: Data > Get data > from folder.
Then filter the list to the files you want.
In the titles there will be a double arrow pointing up and down - click this.
This should get you 90% of the way there. Good luck.
Well done!
Is there a common identifier across each file
Then power query is your best bet
Power Query.
Make sure you set you specify names to each of your Tables, before you use them into PowerQuery.
Power Query or learn Power BI quickly.