

Trusted Members

October 18, 2018

Mcode
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"Attribute"}, {{"Data", each _, type table [#"Period: - Fortnightly"=text, Attribute=text, Value=number]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Data],"INDEX",1,1)),
#"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Period: - Fortnightly", "Value", "INDEX"}, {"Custom.Period: - Fortnightly", "Custom.Value", "Custom.INDEX"}),
#"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Data"}),
#"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Custom.Period: - Fortnightly", "Attribute", "Custom.Value", "Custom.INDEX"})
in
#"Reordered Columns"
1 Guest(s)
