Forum Discussion
mikeborg82
Advocate II
Advocate IITable transformation (pivot unpivot????)
Table transformation... the top three rows are how the data appears, I want the data to look like it does below in one row... i assume this is possible, any ideas and help? Thank you so much.
| Rank | Name | Rating | Number of ratings | ||
| 1 | Kentucky Brunch Brand Stout | 4.84 | 615 | ||
| 1 | Toppling Goliath Brewing Company | 4.84 | 615 | ||
| 1 | American Double / Imperial Stout / 12.00% ABV | 4.84 | 615 | ||
| Rank | Name | Name 2 | Name 3 | Rating | Number of ratings |
| 1 | Kentucky Brunch Brand Stout | Toppling Goliath Brewing Company | American Double / Imperial Stout / 12.00% ABV | 4.84 | 615 |
Indeed, a little bit from both because this includes some logic I recntly learned from ImkeF
let Source = Table1, Grouped = Table.Group(Source, {"Rank", "Rating", "Number of ratings"}, {{"Names", each Table.FromRows({[Name]}), type table}}), Reordered = Table.ReorderColumns(Grouped,{"Rank", "Names", "Rating", "Number of ratings"}), ExpandedNames = Table.ExpandTableColumn(Reordered, "Names", Table.ColumnNames(Table.Combine(Reordered[Names]))), RenamedColumns = Table.TransformColumnNames(ExpandedNames, each Replacer.ReplaceText(_, "Column", "Name ")) in RenamedColumns
3 Replies
- Greg_Deckler
Community Champion
That's a question for MarcelBeug or ImkeF.
- MarcelBeug
Indeed, a little bit from both because this includes some logic I recntly learned from ImkeF
let Source = Table1, Grouped = Table.Group(Source, {"Rank", "Rating", "Number of ratings"}, {{"Names", each Table.FromRows({[Name]}), type table}}), Reordered = Table.ReorderColumns(Grouped,{"Rank", "Names", "Rating", "Number of ratings"}), ExpandedNames = Table.ExpandTableColumn(Reordered, "Names", Table.ColumnNames(Table.Combine(Reordered[Names]))), RenamedColumns = Table.TransformColumnNames(ExpandedNames, each Replacer.ReplaceText(_, "Column", "Name ")) in RenamedColumns
mikeborg82wow, that is awesome!! It worked brilliantly.
