Grouping ages in PQ

[INN]

Hello
Can I group by age in Power Query? I know how to do that using Pivot Table but I am wondering if I can do the same in Power Query without writing a M code. I tried Group By in PQ but that did not group ages to sub group rather it merge (unique) ages.

Book1
	A	B
1	Age	Salary
2	61	77958
3	65	52484
4	44	92752
5	26	34557
6	51	101803
7	31	98396
8	26	159911
9	54	41524
10	65	77425
11	64	105667
12	48	130918
13	24	150019
14	66	112070
15	36	131130
16	39	89904
17	35	185295
18	52	100840
19	35	59644
20	57	186253
Sheet1

I want to create table like below using PQ

Book1
	H	I
3	Row Labels	Sum of Salary
4	24-33	442883
5	34-43	465973
6	44-53	426313
7	54-63	305735
8	64-73	347646
9	Grand Total	1988550
Sheet1

 

[alansidman]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Age", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Age Range", each if [Age]>23 and [Age]< 34 then "24-33"
else if [Age]>33 and [Age]<44 then "34-43"
else if [Age] >43 and [Age]<54 then "44-53"
else if [Age] > 53 and [Age]<64 then "54-63"
else "64-73"),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Age"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Age Range"}, {{"Sum Salary", each List.Sum([Salary]), type number}}),
    #"Sorted Rows" = Table.Sort(#"Grouped Rows",{{"Age Range", Order.Ascending}})
in
    #"Sorted Rows"