Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Combing Tables

 

 

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.

 

 

Need Help
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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.