Hey @Justin_Saunders,
Wanted to flag the concept laid out in this community post with you: How to delete empty columns / conditional delete of column basic on text string?
I’d look into combining these steps with the Merge duplicate rows
step. Hope this helps – let us know how this approach works for you!