Dealing with Arrays

So I have a column that contains a multiple arrays for example Cell 1 contains [ID,A2,A3] and Cell 2 contains [B1,B2,B3] both these cells are in the column. I need to match ID with the same ID in another table and then be able to replace ID in Cell 1 with information from the other table. If you need me to elaborate more let me know :))

Hey Ethan :wave:

There are a few ways to go about this, but it would be helpful to see the current state of your data. Can you share some examples or mock data of your current formatting and your desired formatting?