Combining filed data

user07387

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:

ID	deployed asset
1	Phone
2	phone
2	laptop
2	tablet
2	monitor
3	phone
3	laptop
3	tablet

 

I want the row to look like

1	Phone
2	phone laptop tablet monitor
3	phone laptop tablet

 

Your help would be appreciated

laura_igl

Hi,

Is anyone able to help out with this request?

Thanks,