Hello! I am trying to accomplish something semi complicated I think with a SQL table I have. I have attached a visual demo in Excel of what I want to do. Basically, I want to search through a table and locate all records with the same FirmName values. If I find any, I want to append the values in field3 thru field7 to the end of the first record. Then I want to delete the records I copied and pasted from, and just keep the first one which I copy and pasted to. So in the attached, I would keep record 2 and delete records 3 and 4. Now I cannot be sure how large these groups can be, sometimes it is a pair, and sometimes it could be as many as 5 or more even. But simply put, I want to stick those values from the subsequent records on the end of the first record and delete those subsequent records. Does anyone know how I can accomplish this?