I'm creating a chart of a number of items (website traffic sources) and want to find a way to merge any rows that contain 'Facebook' in the chart.
Here's the raw data:
(direct) 67
192.com 0
bing 21
en-gb.facebook.com 0
facebook.com 2
google 429
l.facebook.com 10
l.instagram.com 0
linkedin.com 0
lm.facebook.com 18
And here's how I'd like the data to look before I create the chart:
(direct) 67
192.com 0
bing 21
Facebook 30
google 429
l.instagram.com 0
linkedin.com 0
I'm aware I could do this using column filters but the data is updated automatically each day so filtering won't work.
I think what I need is a more dynamic solution (maybe a query?) but not sure how to go about writing this.
Any clever people out there know how I could achieve this?