I'm trying to merge several tables into one master table on its own sheet. Each sheet has its own table and there are 15 or so sheets. Every table has the exact same column headings which should make things easier. Each table will likely have a different number of rows, and the number of rows will change (infrequently).
I feel like this should not be hard to pull into one table but I haven't been able to find a solution. It's essentially just merging rows. It would be useful if the master table accommodated the dynamically expanding or contracting number of rows on the source tables, but I'm sure a workaround could be found if that's not handy.
Please help me create One Table to Rule Them All. (Alternatively.... There Can Be Only One, depending on your age.)
I feel like this should not be hard to pull into one table but I haven't been able to find a solution. It's essentially just merging rows. It would be useful if the master table accommodated the dynamically expanding or contracting number of rows on the source tables, but I'm sure a workaround could be found if that's not handy.
Please help me create One Table to Rule Them All. (Alternatively.... There Can Be Only One, depending on your age.)