You can create a unique ID on each record in your file by creating a new dataset view and creating a new field using the formula below.
UID = substring(MD5(RAND(748319383)),1,10)
Then create another new dataset view from the previous dataset and aggregate on the fields of interest by your non-unique ID and also determine the minimum value for your new unique ID field. Call this Min UID.
Finally join the just created aggregated view to the previous created view using UID and Min UID. This will keep one record per original ID with all of the information associated with the specific record that happened to have the minimum UID and will append the aggregated information.