Think it will be alright, ignore that for now.
What version are you on?
Hi Melissa
Excel Version - we are on 365 - but as we are a Not For Profit I think we only get updates twice a year
IT WORKED !!!
I followed your lead and was careful and it worked.
How would I be able to insert into the table the file name of the file that the data on the row came from/
Also can you point me in the direction of some text documents and EDNA material / courses that explains the Sample File methodology and what thedifferent parts of the sloution do?
Allister
So glad to hear that Allister. Excellent!
For a better understanding of the solution, just try to work through the steps depicted in posts #2 and #38. The “Sample File” methodology is native to Power Query in the way we had set it up, see post #20.
I think you must agree that this thread has become ridiculously long, so could you please open a new thread. Add my solution and test files - so we can tackle the file names next
Melissa
Will do in the next couple of days.
Thank You so so much for your skill and patience.
Allister