Forum Discussion
Combine data from 3 different spreadsheets
I've seen some posts that nearly address my issue but not quite. I receive 3 reports each month. these come from 3 different finance teams that operate with 3 different systems. This means the col...
You can combine the 3 tables by using a union. Go to the modelling tab, select new table and enter the logic below (the table names will need updating to what you have called them):
Combined Table = UNION(Table 1,Table 2,Table 3)
Please use the link below to learn more about the UNION function:
All fixed now and working perfectly. I just started again and used a different table as my starting point. I moved the columns around in the other tables and it worked. Not sure what the issue was.
Glad this has worked for you!