How to merge rows contain same id and remove null values of duplicate rows in Power BI

Question

Here My Table contains five columns that are the same value and the other three columns are mixed null values due to this duplicate columns are generating.Help me to resolve this.

Answer 1

After reading the many articles found a solution, we need to use the group by selecting the value which you need distinct and apply conditions where we need to merge columns

After applying the aggregation result will be given below