Forum Discussion
Combine data from 3 different spreadsheets
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:
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:
Thanks for the suggestion. That doesn't work because the tables have a different number of columns in a different order. I need to be able to say something like combine these tables so that column 1 in table 1 = column 3 in table 2 and column 5 in table 3 etc.