Forum Discussion
consolidate data (specific columns) from dynamic table list
Hi Mario_Passweg , here's a solution on PQ I could manage to do. Take a look and let me know if I understood your query correctly.
1. If you look at the second table, you'll see the "Content" column containing your tables (before filtering out for the irrelevant columns). This expands and gets added as and when you add more tables to the excel file.
2. Using Table.Combine(Source[Content]) will give you the combined table to work with.
3. What I've done to get to the sum for Junior / Senior is use the grouping function in Power Query.
4. I'll just drop the M code used for better reference.
Let me know if I solved your query. Thanks very much!
Hi Mario_Passweg , here's a solution on PQ I could manage to do. Take a look and let me know if I understood your query correctly.
1. If you look at the second table, you'll see the "Content" column containing your tables (before filtering out for the irrelevant columns). This expands and gets added as and when you add more tables to the excel file.
2. Using Table.Combine(Source[Content]) will give you the combined table to work with.
3. What I've done to get to the sum for Junior / Senior is use the grouping function in Power Query.
4. I'll just drop the M code used for better reference.
Let me know if I solved your query. Thanks very much!
it worked! Thank you very much!