SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1700573%22%20slang%3D%22en-US%22%3EReference%20Cell%2C%20Pull%20in%20Highest%20%2F%20Second%20Highest%20%2F%20Third%20Highest%20Number%20%26amp%3B%20Cell%20Next%20to%20It%20Into%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1700573%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20in%20the%20field%20of%20SEO%2C%20where%20I%20have%20massive%20amounts%20of%20data%20I%20need%20to%20analyze.%20It%20would%20make%20my%20job%20significantly%20easier%20if%20I%20could%20pull%20in%20the%20keywords%20a%20specific%20URL%20ranks%20for%2C%20along%20with%20the%20number%20of%20clicks%20those%20keywords%20generated%20for%20a%20given%20URL.%20Ideally%20this%20new%20table%20would%20be%20organized%20by%20clicks%20from%20highest%20to%20lowest.%20The%20view%20needs%20to%20be%20transposed%20(as%20pictured%20below)%2C%20and%20I%20need%20to%20be%20able%20to%20see%20the%20keyword%20associated%20with%20that%20volume.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20included%20an%20image%20below%20of%20an%20example%20that%20should%20do%20a%20better%20of%20explaining%20what%20I'm%20trying%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20valued%20greatly%20by%20my%20team%20and%20I!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LWR_Recording.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221294i642712C711F13983%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22LWR_Recording.png%22%20alt%3D%22LWR_Recording.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1700573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1700714%22%20slang%3D%22en-US%22%3ERe%3A%20Reference%20Cell%2C%20Pull%20in%20Highest%20%2F%20Second%20Highest%20%2F%20Third%20Highest%20Number%20%26amp%3B%20Cell%20Next%20to%20It%20In%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1700714%22%20slang%3D%22en-US%22%3EGlad%20to%20help%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F804441%22%20target%3D%22_blank%22%3E%40mdh1993%3C%2FA%3E%20%2C%2C%20keep%20asking%20%E2%98%BA%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1700701%22%20slang%3D%22en-US%22%3ERe%3A%20Reference%20Cell%2C%20Pull%20in%20Highest%20%2F%20Second%20Highest%20%2F%20Third%20Highest%20Number%20%26amp%3B%20Cell%20Next%20to%20It%20In%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1700701%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%26nbsp%3BThis%20is%20exactly%20what%20I%20needed.%20Thank%20you%20Rajesh!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1700688%22%20slang%3D%22en-US%22%3ERe%3A%20Reference%20Cell%2C%20Pull%20in%20Highest%20%2F%20Second%20Highest%20%2F%20Third%20Highest%20Number%20%26amp%3B%20Cell%20Next%20to%20It%20In%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1700688%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F804441%22%20target%3D%22_blank%22%3E%40mdh1993%3C%2FA%3E%26nbsp%3B%2C%2C%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20worked%20out%20with%20two%20possibilities%2C%2C%2C%20find%20the%20solution%20in%20attached%20file%2C%20and%20read%20the%20instructions%20carefully.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_0-1600837336534.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221330i49E8708ABC05448F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Rajesh-S_0-1600837336534.png%22%20alt%3D%22Rajesh-S_0-1600837336534.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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!

 

LWR_Recording.png

3 Replies
Highlighted
Best Response confirmed by mdh1993 (New Contributor)
Solution

@mdh1993 ,,,

 

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

 

Rajesh-S_0-1600837336534.png

 

Highlighted

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

Highlighted