If I have two tables with the same exact number of columns with the same headers but different data on two different sheets. How do I combine them?
I don't want to Copy & Paste because I need to learn this in case the two datasets are very large.
I have been at this for literally hours and it seems so simple yet it is being soooo difficult.
Literally just take a two tables from two sheets and combine them, so that I may pivot table and query them.
I don't want to Copy & Paste because I need to learn this in case the two datasets are very large.
I have been at this for literally hours and it seems so simple yet it is being soooo difficult.
Literally just take a two tables from two sheets and combine them, so that I may pivot table and query them.