Consolidating data from multiple rows

[Thomas_Walker]

Some context: I’m doing a content audit, and part of that is seeing which keywords are associated with a given URL.

Right now, all of that information is in a single sheet, with each keyword on it’s own row.

Problem is, since there’s only one keyword per row, I end up with multiple rows with the same URL but different keywords.

What I would like to do is two-fold.

1. In Google Sheets consolidate it so I can look at a single URL and see all of the keywords associated with that.

2. Bring that keyword information into the URL fields that are in the AirTable base I’m using to manage the entire process.

I imagine there’s something to do with pivot tables here, but I have no idea how those work and need some serious hand holding.