Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
60
Views
Topic starter
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
Posted : 17/02/2020 4:36 am
Hi Jordan,
I suspect there might be a space lingering in one of them. Have you used Trim/clean in the Extract drop down?
Mynda
Posted : 17/02/2020 7:17 am
Topic starter
thanks it worked!
Posted : 19/02/2020 11:36 am
