Duplicating a table in Power Query and Appending the duplicates into one table

Hi Syndicate_Admin ,

Your requirement to duplicate these tables X times and then append seems a little odd.

I'm going to answer this on the assumption that your actual question was "How do I get a table that contains all unique combinations of [Project] and [Resource]?". If I've got this wrong feel free to explain further, but here's my answer to the imagined question:

-1- Duplicate your Unique Projects query by right-clicking on it in the Queries pane and selecting Duplicate (this is just so you get to keep the original, it's not a critical step).

-2- In the new query, add a new Custom Column that references your entire resource table, like this:

-3- This will give you a nested resource table on every row of the project table that you can expand using the button circled below to create a crossjoined table:

You should now have a table that contains all possible combinations of [Unique Project] and [Unique Resource Name], something like this:

Pete