I have a program that puts out some data tables on a sheet with some useless data in-between. (Example is sheet "test" in attached file -- it only shows two data tables, but could be more). I need to consolidate those tables into a single table, get rid of the data in-between, and add a few columns.
I also need to remove duplicates by two criteria, and give a count of all the duplicates removed.
The other sheet, "Result" shows what the final output should be, and has a list of all the things that have to happen.
I tried a bunch of stuff with macro recorder, came close, but not cigar (and it was a mess). Would be grateful if someone with VBA skills could help.
Thank you very much, in advance!