Forum Discussion
Excel 2016 power Query how to consolidate data into one common row
You may reference on the query and
1) Merge all NNN Loop Number columns into one column, let say Merged
2) Group By Loop Number with aggregating Merged column on Sum
3) Change in formula bar List.Sum([Merged]) on Text.Combine([Merged],",")
Reference on initial query once more and merge with previous one
Many Thanks, after tweaking the following worked (Group By Advanced):
= Table.Group(#"Sorted Rows", {"Loop Number"}, {{"Sum1", each Text.Combine([IO1 Loop Number],","), type text}, {"Sum2", each Text.Combine([IO2 Loop Number],","), type text}, {"Sum3", each Text.Combine([IO3 Loop Number],","), type text}, {"Sum4", each Text.Combine([IO4 Loop Number],","), type none}, {"Sum5", each Text.Combine([IO5 Loop Number],","), type none}, {"Sum6", each Text.Combine([IO6 Loop Number],","), type text}, {"Sum7", each Text.Combine([IO7 Loop Number],","), type none}, {"Sum8", each Text.Combine([IO8 Loop Number],","), type none}})
recho , you are welcome, glad to know you sorted this out