consolidate a table on a monthly basis from multiple files

[TK177]

Dear Community, 

on a monthly basis I receive 19 Excel files from different countries with various tabs. On of those Tabs is Called "10_R&O". This Tab has the followin table as content:

This table is in every Excel file the same.

I want to have a power query that consolidates all the tables into one

I have tried several times after combining the files in power query with different Index columns but failed every time.

Does anyone has an idea how to do this in power query and can provide a step by step guidance?

Thanks in ad

[Anonymous]

Hi @TK177 ,

Thanks for reaching out.

According to your description, I think you could learn about Append Quries feature in Power Query.

The append operation creates a single table by adding the contents of one or more tables to another, and aggregates the column headers from the tables to create the schema for the new table.

Append queries - Power Query | Microsoft Learn

If you still have doubts, please explain in more detail with expected results as lbendlin said.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...