I am working on a dataset where I want to combine multiple nested tables into one big table. The nature of the nested tables are in the attached screenshots below; each nested table contains a "Unique" column which is common to all of them and I want the end result to contain one Unique column and all the rest of the columns from each nested table in one table.
I think I am right in saying that, I am trying to join all these tables dynamically.
I would really appreciate it if you could suggest me a way.
Example table 1
Example table 2
Below is a screenshot of the end goal.