Hi Team,
This is hopefully a easy ask
Where there are multiple entities (Rows) for a given "Comp Id" then append the names from the different rows together (Separated by a semicolon ) against a given Comp ID
Input
Comp ID | Name |
11111 | John Doe |
11111 | Silver Fox |
22222 | Grey Goose |
Expected Out put
Comp ID | Name |
11111 | John Doe ; Silver Fox |
22222 | Grey Goose |
Looking forward to your help
Many Thanks
Regards
Masond3
Solved! Go to Solution.
Hi @Masond3
Very important, usually the concatenate Separator in default will be ,
Kindly modify as ; to get your output.
Kindly accept this solution if it provided a solution to your question.
Many thanks
Shanker V
I was trying to do this in cross tab :)
Thanks the pointer - really appreciate it