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!!
Solved! Go to Solution.
Yes, It combines values but it keeps duplicated values within the licenses column.
Could you please help on this?