Forum Discussion
Pete_Murphy_71
3 years agoRegular Visitor
Simple question, How to summarize rows
Hi, I have what should be a simple issue but I just can't seem to sort this one out (perhaps I need more coffee ☕🤣) I have two columns, in my example data first a city and second a comment about...
- 3 years ago
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.
Anonymous
3 years agoNot applicable
Use a matrix instead of a table. City as rows, description as values.
- Pete_Murphy_713 years agoRegular Visitor
Thanks, I really appreciate your help, but unfortunately it didn't work. I put City as Rows and Description of Values but it only gave the first description. Here is what happened.
It is missing the other descriptions..... This seems to be a tougher question than I originally thought..