Combining filed data
How do I combine data from the same field on different rows into one?
To make it simple, lets say there are two columns.
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
I want the row to look like
Your help would be appreciated