Solved: Combing Tables

Anonymous · ‎07-01-2019

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 · ‎07-10-2019

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.

View solution in original post

v-juanli-msft · ‎07-10-2019

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 · ‎07-01-2019

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 · ‎07-01-2019

@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.