How to group the data of the Multiple rows to a column

[Anonymous]

I have a task and trying to group the data which is in Multiple rows

Consider below the data in the Table

FileName                    Sharedwith

test.docx                      abc@123.com

test.docx                      xyz@123.com

test.dox                        123@abc.com 

test1.pptx                     abc@123.com 

test1.pptx                     zz@xyz.com 

and the output expected is

FileName                     Sharedwith

test.docx                     abc@123.com , xyz@123.com, 123@abc.com

test1.pptx                   abc@123.com, zz@xyz.com 

Request to help in how to group the data

Thanks in Advance.

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file from your onedrive business.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @Anonymous 

We can build a calculated column to solve this problem：

Group = CONCATENATEX(FILTER('Table','Table'[FileName]=EARLIER('Table'[FileName])),'Table'[Sharedwith],",")

Result is as below：

You can download the pbix file form this link:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/tongzhou_qiuyunus_onmicrosoft_com/EbZMXeVO48lMtjVkCefJ4mcBMp81aeN2KirjD6tYFdyheg?e=ZvkNhf

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.