How do I change the M code to ensure any new columns added each month will get included? Edited

[michellerob2000]

I noticed I had to manually type in the additional Approver columns after refresh from 8 to 11

Is there a way if doing that with a different code so any new approver columns will automatically be added?

let
Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"App Group name", type text}, {"App Group name(T)", type text}, {"User", type text}, {"Description", type text}, {"User type(T)", type text}, {"Value", Int64.Type}}),

#"Grouped Rows" = Table.Group(#"Changed Type", {"App Group name"}, {{"Approver", each Text.Combine([Description], ", ")}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Grouped Rows", "Approver", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Approver.1", "Approver.2", "Approver.3", "Approver.4", "Approver.5", "Approver.6", "Approver.7", "Approver.8",}), "Approver.9", "Approver.10", "Approver.11"
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Approver.1", type text}, {"Approver.2", type text}, {"Approver.3", type text}, {"Approver.4", type text}, {"Approver.5", type text}, {"Approver.6", type text}, {"Approver.7", type text}, {"Approver.8", type text}, {"Approver.9", type text}, {"Approver.10", type text}, {"Approver.11", type text}})
in
#"Changed Type1"

Thanks you in advance

[slorin]

Hi,

= Table.TransformColumnTypes(
   #"Split Column by Delimiter",
   List.Transform(
     List.Select(
       Table.ColumnNames(#"Split Column by Delimiter"), 
       each Text.StartsWith(_,"Approver")),
     each {_, type text})
  )

Stéphane 

[michellerob2000]

thank you but where about in the advanced editor do I add that? I gave my current in my post at the top

[slorin]

#"Changed Type1"

#"Changed Type1" = Table.TransformColumnTypes(
   #"Split Column by Delimiter",
   List.Transform(
     List.Select(
       Table.ColumnNames(#"Split Column by Delimiter"), 
       each Text.StartsWith(_,"Approver")),
     each {_, type text})
  )

 Stéphane

[michellerob2000]

I am expecting more approvers to be added after the 11th. 

[PijushRoy]

@michellerob2000 
Is it limited to Approver 11 or you want more column