Hi @KungFooLemmi, thanks for the question. I think that SQL would be the best way to join these rows. Here's another forum post that's somewhat similar, and I think that the reply might be useful to you, too! https://community.retool.com/t/joining-the-tables/27943/2 
Let me know if this doesn't work, or if there's anything else that we can help with