Sep 22 2020 05:55 PM
I work in the field of SEO, where I have massive amounts of data I need to analyze. It would make my job significantly easier if I could pull in the keywords a specific URL ranks for, along with the number of clicks those keywords generated for a given URL. Ideally this new table would be organized by clicks from highest to lowest. The view needs to be transposed (as pictured below), and I need to be able to see the keyword associated with that volume.
I've included an image below of an example that should do a better of explaining what I'm trying to do.
Any help would be valued greatly by my team and I!
Sep 22 2020 09:37 PM - edited Sep 22 2020 10:04 PM
Solution@mdh1993 ,,,
I've worked out with two possibilities,,, find the solution in attached file, and read the instructions carefully.
Sep 22 2020 09:51 PM
@Rajesh_Sinha This is exactly what I needed. Thank you Rajesh!
Sep 22 2020 10:06 PM
Sep 22 2020 09:37 PM - edited Sep 22 2020 10:04 PM
Solution@mdh1993 ,,,
I've worked out with two possibilities,,, find the solution in attached file, and read the instructions carefully.