New column in source table not appearing after refresh

[michellerob2000]

When I click on Refresh after adding in updated data, ie has extra 2 columns, this is not included in the table.

In the table currently has 7 columns, but in my source has 11 columns. How do I ensure the whole of the source worksheet is including any extra columns?

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[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"}, {{"Description", each Text.Combine([Description], ", ")}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Grouped Rows", "Description", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Description.1", "Description.2", "Description.3", "Description.4", "Description.5", "Description.6", "Description.7"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Description.1", type text}, {"Description.2", type text}, {"Description.3", type text}, {"Description.4", type text}, {"Description.5", type text}, {"Description.6", type text}, {"Description.7", type text}})
in

Thanks 

Michelle

[baghdadi62]

You have used "group by" in the data cleansing process. The question is, how will their placement in the grouping change when new columns are added?

[baghdadi62]

In 3rd step you grouped table that affectes on the result and you can't see the extra columns because they didn't use in "group by" step.

[michellerob2000]

Great so what is the solution?