Deleting Some Duplicate Data

[Anonymous]

Hello! I am very new to power BI so forgive me if this is simple question. 

I am trying to show who is on a particular project, while not displaying redundant information.

Data comes into power bi ( more or less)  like this :

Note: There is code to take an ID and match it to a name.

This issue is for the project "Notebooks" there are two BA's working on it, and when I create a table to display who is working on a specific project I get this :

When really want this to dispaly:

Any Ideas / suggestions would be much apprerciated!

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous  ,

Here is what I suggest:

> Create a new MATRIX visual 
> Add all relevant columns (as below)

> Hover your mouse on the visual and press on 

     button until greyed out.

> Go to FORMAT tab > Row Headers > Turn off STEPPED LAYOUT

> You should then get the below matrix

Cheers
Robin

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

[Anonymous]

@Anonymous 

Thanks for the inital solution this worked until I had two columns with more than person in it. So instead of getting this:

I would get this:

Any ideas? Thanks