Hi there! I have a small project that I need doing really quickly. I have a spreadsheet with a load of data. In Column A is a list of 20k+ search terms customers have used to find my website. In Column B is a list of some of my core keywords. I'd like the data manipulated so that, on a different sheet, each of the core keywords becomes a column header, and any of the search terms from Column A that contain a search term fall under the relevant keyword column in sheet 2. Please note that I also need to hold onto the analytics data (Sessions, % New Sessions, New Users etc.) for each search term.
Basically Im looking to see how valuable each keyword is to me by seeing how many times they have been searched in the last 3 years