Combining filed data

Hi,

How do I combine data from the same field on different rows into one?

To make it simple, lets say there are two columns.

Data Source:

Column 1=ID

Column 2=deployed asset

There could be different rows with the same ID but unique deployed asset

How can I combine the two deployed asset fields  into one and  so I am left with one row per ID

Example:

I want the row to look like

Your help would be appreciated