Forum Discussion
Need to concatenate String values based on User Email Address
Hi All,
I have a License report where each user and it will hold multiple lines of entries with respect to their assigned licenses. I would like to combine the User license details for each user and put them on a cell separated by Comma. Also, it will have duplicate license name for each user, We need to pick the unique licenses and need to concatenate them with comma. Below is a sample exported report and the Required output format.
Looking for some help on this. Thanks in Advance!!
Hope this video helps:
4 Replies
- AnonymousNot applicable
- AnonymousNot applicable
Yes, It combines values but it keeps duplicated values within the licenses column.
Could you please help on this?
Thank you.
- PadycosmosSolution Sage
Hope this video helps:
- PadycosmosSolution Sage
In the column containing the original data, you can right click and remove duplicates as shown below and then combine rows: