Table transformation (pivot unpivot????)

[mikeborg82]

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

[Greg_Deckler]

That's a question for @MarcelBeug or @ImkeF.

[MarcelBeug · Accepted solution]

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

[mikeborg82]

wow, that is awesome!!  It worked brilliantly.