Forum Discussion
Simple question, How to summarize rows
It depends a little, on what you want to achieve. Do you want to model the Data in PowerQuery to match this structure? Then try Grouping:
let Source = "Your Source!", #"Group" = Table.Group(Source, {"Place"}, {{"Description", each Text.Combine([Description],";")}}), #"Split Column" = Table.SplitColumn(#"Group", "Description", Splitter.SplitTextByDelimiter(";", QuoteStyle.Csv), {"Description.1", "Description.2", "Description.3"}) in #"Split Column"Edit: this will be the output in Table View:
If it is merely a Question of Visual representation try a Matrix and add both Data Fields to the "Row" Section.
It depends a little, on what you want to achieve. Do you want to model the Data in PowerQuery to match this structure? Then try Grouping:
let
Source = "Your Source!",
#"Group" = Table.Group(Source, {"Place"}, {{"Description", each Text.Combine([Description],";")}}),
#"Split Column" = Table.SplitColumn(#"Group", "Description", Splitter.SplitTextByDelimiter(";", QuoteStyle.Csv), {"Description.1", "Description.2", "Description.3"})
in
#"Split Column"
Edit: this will be the output in Table View:
If it is merely a Question of Visual representation try a Matrix and add both Data Fields to the "Row" Section.
Thank you for taking the time to help me. I appreciate your help.
It looks like I needed to do this solution using M code as part of the GroupBy function. In particular
Text.Combine([Description],";")
I could not work out how to do this from the GroupBy button.
Again, thank you for taking your time to help me.