Excel将基于3列的类似行合并为一行

OK, So I have a spreadsheet that was made by combining two identically structured spreadsheets that merged all the data into one. The problem is that both spreadsheets have "similar" data but one has more data than the other but both have data that is missing in each of the spreadsheets but all the data is required to be kept. One suggestion I was given was to manually go through the spreadsheet row by row to combine the rows. Given there are 5000 rows in this spreadsheet, this option is not desirable. I did find a VB Script that allowed me to combine rows of similar information, the problem was it seems to only combine everything into on row based on one column of information.OK, So I have a spreadsheet that was made by co