Pull and display data in a unique way from two different sheets?

[ccastell88]

Hi Guys,

Basically i want to pull data from two different sheets (keyword and volumes + URLs) in the attached workbook and make it look like the output (example of output sheet) or something very similar in the example of output sheet.

So each URL from the URLs sheet has the all the related keywords sorted by search volume from the keywords and volumes sheet as shown in the example of output.

I think this is a doable with a pivot table but beyond my current excel expertise to mentally figure it out.

Any suggestions would be very much appreciated!

Cheers,
Chris