Need to concatenate String values based on User Email Address

[Santhosh_V]

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!!

[Padycosmos]

In the column containing the original data, you can right click and remove duplicates as shown below and then combine rows:

[Padycosmos · Accepted solution]

Hope this  video helps:

https://www.youtube.com/watch?v=6g49UJ096NE

[Santhosh_V]

@v-yueyunzh-msft , @FreemanZ @Padycosmos , Any help on this?

Thank you!

[Santhosh_V]

@Padycosmos,

Yes, It combines values but it keeps duplicated values within the licenses column.

Could you please help on this?

Thank you.