Hi All,

I would like to know if there is a formula that will remove all duplicate rows. However, there is one column of data that is not duplicated, and I would like to preserve that data and move it into a new row.

Here is an example:

12361646 AvisRentACar A 7811 Waynetowne Blvd Dayton OH Restaurants
12361646 AvisRentACar A 7811 Waynetowne Blvd Dayton OH Auto Rentals
12361646 AvisRentACar A 7811 Waynetowne Blvd Dayton OH Auto Leasing
12361646 AvisRentACar A 7811 Waynetowne Blvd Dayton OH Furniture Rental

to become

12361646 AvisRentACar A 7811 Waynetowne Blvd Dayton OH Restaurants Auto Rentals Auto Leasing Furniture Rental