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
Erokor's avatar
Erokor
Resolver II
2 years ago

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'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