Get and Transform (Power Query) - Grouping numbers into bands/buckets

Hi

Wonder if anyone can advise on this challenge I am facing please?

In excel I would just use a lookup without True/False (1/0) to determine where a number "fits" in a list of bands but lost on it in G&T. I am looking at the number of staff managers have, I would essentially have a list of managers names in the first column and their staff headcount in the second column, in the third column I want to assign a band to the headcount so, for example:

1-5 Staff
6-10 Staff
11-15 Staff
More than 15 Staff

The list is vast and I am performing a number of manipulations on the data in Get and Transform, so ideally I would like to add this step to my Get and Transform rather than doing it in excel. I am 100% sure that it can be done but my searches have proved fruitless (I am sure I am just using the "wrong" search term when I say band or group).

Thanks

TNU

I don't know much about PQ etc but have you tried adding a conditional column?

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Manager", type text}, {"Headcount", Int64.Type}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Band", each if [Headcount] <= 5 then "1-5 Staff" else if [Headcount] <= 10 then "6-10 Staff" else if [Headcount] <= 15 then "11-15 Staff" else "More than 15 Staff")
in
    #"Added Conditional Column"

the Group element on the G&T is really about thinning the dataset relative to existing values.