Excel combine entries copy paste

I have an excel spreadsheet with 4754 entries. Every two entries are identical except for two pieces of information. I need the two entries combined into one, so that the final spreadsheet will have 2377 entries. I have attached a 28 entry sample, please view the sample before placing your bid. What I need done is to have Column E & F, transfered to columns G & H of the similar entry. For example in the first two entries, line 2, column E&F need to be transferred to line 3, Column G & H, then line 2 needs to be deleted. The surviving entry will always be the one that has "at" in Column C. If you want to send me the completed sample to show that you understand the project, that would be fine. Your bid should be for the entire 4754 entries reduced correctly to the 2377 entries.