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.
-
In Google Sheets consolidate it so I can look at a single URL and see all of the keywords associated with that.
-
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.
