Forum Discussion
Solved
Transpose or ??
This is probably a simple thing, but I haven't found anything that works. It's similar to transpose, but not really. So basically I need the table on the left of the screenshot converted into the t...
(EDITED: Added Option3 that's almost all done with the UI/Menus)
With Power Query
2 options in attached file. Option1_1 is a variation of Option1, in case you hit performance issue with the latter
Option1:
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
GroupedRows = Table.Group(Source, {"Category"},
{"DATA", each
Table.FromRows(
{ {Table.FirstValue(_)} & [Variation] }
),
type table
}
),
CombinedTables = Table.Combine(GroupedRows[DATA])
in
CombinedTables
Maybe I missed it, but I don't see the different options in the file. Thanks