I have some data from analytics that I need to combine somehow and trying to find the best way of doing this. I have data similar to the following:
I want to be able to find a way to first remove any UTM data (ie anything after the question mark) then add up the total sessions from each page. Here, the result I want is this:
I want this formula to be automatic in the way that it read all URLs in Column A until it reaches the end.