Thanks Alansidman as your solution worked out great. I know VBA but this Power Query syntax is foreign to me. Is the code you provided something you learned by doing several Power Queries or is their a library of code snippets somewhere that you can just copy and paste?
Thanks again