Multiple columns from one table into a single column

Hm, if an Event can only be linked to one Customer at a time, then I think I’d use an automation to create one record per program in another table to get the format you want, and I’d use a conditional to filter out the third program if it didn’t exist:
 

And I’ve set it up here for you to check out

If each Event can be linked to multiple Customers, then I’d create a ‘Tasks’ table and have an automation that would create one record in there per Customer tied to an Event, and so each record in there would represent a single Customer <> Event link, and then I'd run the automation above on that new table instead

THANKS!   I’m working my way through this.  I think this might do it.

I have a CUSTOMERS table with links to each event and a column of aggregated programs (A customer can enroll in multiple events)

I have an EVENTS table with a column for each program

I have a REGISTRATION table with “customer_id” and “event_id”

I’m assuming that by using the Automation, I’d be creating a new table altogether (aka “Tasks”, per your comment)

Hmm, so there’s no direct link between Customers and Events, is that right?  It sounds like you could make the automation trigger off of the Registration table instead actually, I’m not sure though, could you provide screenshots of your tables?

Thanks so much for the guidance  I was new to Automations and did not understand their utility.  All fixed now!

Not sure if you still need help as you provided the screenshot but it sounds like you’re all good?  Glad you figured it out if so!