Hey @matt_stewart1!
My recommendation is that in the table that you’re trying to summarize, you create a single formula field that acts as a summary per se.
I was helping another person on the forums a while ago and created a base as an example for them to reference.
In that base, I implemented what I just described.
Here’s what that looks like…

You can see that the Gear Tag
field contains information from the different fields on the record.
Then would allow me to get all the information from that formula into a lookup/rollup without having to create a ton of data bloat by creating a 1:1 lookup field for each value I want to reference in the other table.
I have a user bug report ticket in front of me right now and am using the Airtable forums as a distraction, thus my brain is kinda scattered right now.
It’s totally possible that I read your post too fast, so if there’s something I’m missing or if you have any additional questions, please don’t hesitate to reply!