Reset index number each different value

[gargamalebarbosa]

Hi,
I have a list in Column A. I want to create Index like in Column B. Index numbers must be change / reset if value change.
Thank you,

 

[Jeffrey Mahoney]

=IF(A1<>A2,1,Sum(B1)+1)

 

[gargamalebarbosa]

Sorry it was my mistake. I need Power Query solution. Sorry..

 

[RoryA]

You could do something like this:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"List", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"List"}, {{"Data", each Table.AddIndexColumn(_, "Index", 1, 1), type table}}, GroupKind.Local),
    #"Expanded Data" = Table.ExpandTableColumn(#"Grouped Rows", "Data", {"Index"}, {"Index"})
in
    #"Expanded Data"

 

[gargamalebarbosa]

You could do something like this:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"List", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"List"}, {{"Data", each Table.AddIndexColumn(_, "Index", 1, 1), type table}}, GroupKind.Local),
    #"Expanded Data" = Table.ExpandTableColumn(#"Grouped Rows", "Data", {"Index"}, {"Index"})
in
    #"Expanded Data"

Thank you so much ..