Hello,
I have two data tables in Excel that have the same exact headings from two workbooks that I am trying to combine. When I say combine, I mean that I want to add the tables together without merging or concatenating the data. sets; having each record in each data table as being unique. I have tried using the Power Query, but without no luck. I have a feeling that I will need to have code to copy and paste one table to the workbook, then copy and paste the second table to the next empty row, but not sure what to do.
Thank you,
Mack
I have two data tables in Excel that have the same exact headings from two workbooks that I am trying to combine. When I say combine, I mean that I want to add the tables together without merging or concatenating the data. sets; having each record in each data table as being unique. I have tried using the Power Query, but without no luck. I have a feeling that I will need to have code to copy and paste one table to the workbook, then copy and paste the second table to the next empty row, but not sure what to do.
Thank you,
Mack