Hi there,
I am currently working on a project to summarize data across multiple bases. I have set up share links so that in this single base I have a share table from each of my other bases. Each of these tables is laid out the same way
[Name] [Amount] [Date Purchased] [Store Purchased]
I want to combine these records from these multiple tables into one big table e.g
If table 1 looks like:
[Name] [Amount] [Date Purchased] [Store Purchased]
Aaron, 10, 10/11, New York
Abby, 34, 10/12, New York
And table 2 looks like:
[Name] [Amount] [Date Purchased] [Store Purchased]
Aaron, 21, 10/30, Los Angeles
Anna, 34, 10/31, Los Angeles
Then my final table would look like
[Name] [Amount] [Date Purchased] [Store Purchased]
Aaron, 10, 10/11, New York
Abby, 34, 10/12, New York
Aaron, 21, 10/30, Los Angeles
Anna, 34, 10/31, Los Angeles
Is this possible? I am hoping to have these bases to be separate and then converge instead of having all purchases on one table and then separating them into new bases.
Thanks!