Removing duplicate rows to column values

[goodness7]

I'm wondering how I could achieve below output:

I tried group by and other methods but having a hard time.. any help would be appreciated!!

[VijayP · Accepted solution]

@goodness7 

This can be done using power query editor and the result as desired. The attached pbix will help you to understand!