Combing Tables

[Anonymous]

Hi

I have a 500 + excel forms coming in via customers. I need to aggregate the results into one table.  Is this possible in Power Query.

An example would be

Many thanks

Jo.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

First append queries

Then group by columns

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi ,

Yes this is doable in Power BI.

Use datasource as (From Folder) and combine all the excel files into single one.

Thanks,

Nishanth.

[Anonymous]

@Anonymous  thanks for your reply.

Are you able to show me an example with the tables I have provided as I have already tried this and Power BI just appends the tables together rather than aggregating the values

Many thanks

Jo.