Timesheet description consolidation by Unique ID

[Moore]

Hello,

I have a data set for timesheet, where each time entered has a unique ID called the Record ID, some how the data extracted from the timesheet database has placed some of the longer descriptions on the row below it, hence replicating a single the Record ID to several rows below it, however, i would like to only see the data for each Record ID per row, so I'm trying to consolidate the description items related to that Record ID into a single row of data. There are hundreds of rows of data with similar problem, I have attached a sample of the problem and desired result below. Any help is appreciated. Thanks.

[MichalM · Accepted solution]

@Moore 

You'd want to use the Summarize module and Group by all the fields apart from Description and Concatenate on this one with semicolon as a separator

[Moore]

This worked perfectly. Thank you.