Need help merging two sets of data into 1 single record

Ok, this may be super basic, but I really need help here. 

I've got two sets of data: 

1. Google Analytics
2 aHrefs

The Google Analytics data shows values like traffic, user engagement time, pages visited per session, etc and gives all of this for a single url. 

The aHrefs data gives data like keywords, keyword difficulty, search volume, etc, but instead of showing all of this data on a single url, it will give 50 of the same url (this is an arbitrary number) because aside from the url, all of the other data is unique. 

What I would like to do is combine all of that information into a single URL, 

So if there is one url, it will show me all of the different keyphrases it is ranking for, an average of their difficulty, etc. 

I need it all in a single record. 

So far, I've tried de-dupe, but it won't merge the different keyword values into a single field, it will just eliminate multiple of the same, and I'm a weeny with formulas, but tried the CONCATENATE() formula, but it also didn't do what I was looking for. 

Any suggestions?