Help with Flattening to One Row, Transpose with Text Combined

[clgrantmidd]

Hi, I've searched the community for a way to do this.  I've tried grouping then working with subtables but I can't get anything to work.  Below is the raw data then what I need to have.  Grouped by Fund, Fund Desc and Fund Notes

Thanks for any help!

Carol

[AilleryO]

Hi,

Here is a dsicussion that might help you :

https://community.powerbi.com/t5/Desktop/CONCATENATE-AND-CONCATENATEX/td-p/727461

If I understood... your problem is just to concatenate the values in relationship name ?

Have a nice day

[clgrantmidd]

It's a little more complicated then that.

I need to group them by FundID then create 3 new columns with kind of Relationship Type (3 different types) and then list the Relationship Names for each of those 3 Relationship Types comma separated.  It's like Pivoting the Relationship Type with Relationship Names (Text Values) but some have more than one relationship names which I want comma separated.