Forum Discussion

SK2's avatar
SK2
New Member
2 years ago

Remove Duplicate rows by getting value in separate columns

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
Need Help
SK2's avatar
SK2
New Member
2 years ago

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

 

Erokor's avatar
Erokor
Resolver II
2 years ago

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

  • SK2's avatar
    SK2
    New Member
    2 years ago

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