What is the best way to group data in a table?

[santiago_ortiz]

Hello guys, I have the following table:

This is the relationship of the tables where the data came from:

Is there any way to show the table grouped by name?

I tried to use a Matrix but didn't worked as expected because it requires an aggregation over the data:

[santiago_ortiz]

Hello @Ashish_Mathur @Ritaf1983, thanks for your help, the expected result would be the same table but with the name column grouped to avoid duplicates:

For example for the first 4 lines would be as follow:

[Ashish_Mathur]

Hi,

Switch to a Table visual from a matrix visual.

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file and show the expected result.

[Ritaf1983]

Hi @santiago_ortiz 

What do you mean by grouping by name?

What is the expected result?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523