Problem with grouping|Power Query|Excel Forum|My Online Training Hub

Hey,

In my data I have 2 columns named 'Regional centre (RC)' and Costs.

Among the values in the 'RC' column I've had 'Kent Asda' and 'kent BLF'.

I removed the second word from each using Split columns and capitalised them so the only thing remained is 'Kent'.

On the next step, I grouped costs by RC, but Power Query is still identifying the two 'Kent' as different! and producing two sums, one for what was 'Kent Asda' and the second for 'Kent BLF'.

How can I solve this?

Thanks,

Jordan