Reference Cell, Pull in Highest / Second Highest / Third Highest Number & Cell Next to It Into Table

[mdh1993]

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!

[#2 · Accepted solution]

@mdh1993 ,,,

I've worked out with two possibilities,,, find the solution in attached file, and read the instructions carefully.

[#3]

@Rajesh_Sinha This is exactly what I needed. Thank you Rajesh!

[#4]

Glad to help you @mdh1993 ,, keep asking ☺