I have a spreadsheet that contains demographic data. I need help! What I'd like to do is merge two rows that contain the same last name and address. The problem right now is there are two records per provider, and one has a image rec field complete, and the other has the tax id. I need one record that has both. In the attached file, the top four rows are the "as is" state, and the bottom two rows are what I'd like it to look like.