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
