Hi,
I'm currently conducting an exercise with ~20 people and I need to consolidate the data into a master file, however my current approach is really slow.
Each person has their own file and every day they fill in a different excel table (day1, day2, day3, etc). The tables are consistent in their structure.
I've approached it by creating a data query connection that combines for all the files in the folder each day (Q1 = Day1, Q2 = Day2, etc) and then a further data connection that combines the queries. The result is a table 60 columns x 14,820 rows.
Am I expecting too much of excel or is there a better approach to this?
Thanks in advance.
I'm currently conducting an exercise with ~20 people and I need to consolidate the data into a master file, however my current approach is really slow.
Each person has their own file and every day they fill in a different excel table (day1, day2, day3, etc). The tables are consistent in their structure.
I've approached it by creating a data query connection that combines for all the files in the folder each day (Q1 = Day1, Q2 = Day2, etc) and then a further data connection that combines the queries. The result is a table 60 columns x 14,820 rows.
Am I expecting too much of excel or is there a better approach to this?
Thanks in advance.