Remove Duplicate rows by getting value in separate columns

[SK2]

Hi ,

I am new to Power BI and trying to remove duplicates.

Can anyone please help me with this?

This is what i have 

And trying to get it like below.

Thanks for your time

[Erokor]

In Power Query, you can use the "Transpose" feature. Which should get you what youa re looking for. However, you'll need to re-title your column headers.

Alternatively in a "Matrix" visual. You can put the "SH" in the "Rows" portion, and the "Status" in the "Column" and "Values" portion of the visual. You'll also want to set your Aggrigation's appropriately for the "Values" so that it does not sum/count etc.

[SK2]

I tried the matrix visual , and it shows me this 

I added "status" in values portion of visuals - but it changes to count of status .And shows like 

[Erokor]

If you select the little carrot to the right of the "Count of Status" you can then adjust that to "First" or last. Since you only have the value once for each number in the header it would show 1 for 1.

This is really a hacky way to do it. The better way would be to model your data properly up front (using Transpose as I mentioned before).

[SK2]

Got it . i tried the other way also 

[Erokor]

Great! If my solution helped you to achieve the result you are looking for, please select it as a solution to help others find the help they might need in this instance!

[SK2]

Actually , if you look the values in column SH  are also shown in all columns , So i am still struggling 

[Erokor]

Go up a step, and only select the column you want to transpose. You don't want the 373306 column to be transposed.

[SK2]

Yes, Thats what i did , just select status column and did transpose , but it is not the result i  am looking