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.
Hope this video helps:
In the column containing the original data, you can right click and remove duplicates as shown below and then combine rows:
Yes, It combines values but it keeps duplicated values within the licenses column.
Could you please help on this?
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.