Forum Discussion
Pulling exact same data across multiples tables
I've looked around and could not find an answer. Example i have 4 sets of tables like this table 1 table 2 1 20 1...
Hi jordan1213
Alternatively with 8k rows/table I would do it by https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9#:~:text=In%20the%20Merge%20popup%20window%20%20-%20Choose,whether%20you%20need%20to%20make%20...%20See%20More (many videos exist on the Net)
Given you only have 4 tables you can easily do this with almost no knowledge of PQ, repeating the merges one after the other (3 merges in total). Alternatively the attached workbook does it by iterating the list of tables to merge (added an add. dummy record - 96...99 - that matches):