Power Query Doubt

[sureshmandadpu]

Dear Excel Wizards,

I want to get output from Power Query. Actual data size runs into 5000+ rows. I got output using Excel Functions. But file was responding slowly. Kindly help.

Regards,
Suresh M

 

[GraH - Guido]

First try

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Group = Table.Group(Source, {"Name"}, {{"All", each Table.Transpose(Table.SelectColumns(_,"Account No")), type table}}),
    Expand =
    let
    Cols = Table.ColumnNames(Table.Combine(Group[All])),
    NewCols = List.Transform(Cols, each "Account Nr " & Text.From(List.PositionOf(Cols, _)+1)),
    Expanded  = Table.ExpandTableColumn(Group, "All", Cols, NewCols)
    in
    Expanded
in
    Expand

 

[sureshmandadpu]

Thank you, Sir. I will try.