Combining Rows based on unique column id

[oabd0250]

Hi guys i`m trying to combine a sheet in which some cells are completly empty as an example the product name is my unique identifier and i want to make one combined row for each uniqueID" Product name" to collect all the rows together to have one complete infromative row,

PS: rows are exactly the same as belw mentioned " either have value or completly empty"

How can i do so in power query specially if the data is being refreshed from sharepoint sourceBefore ( Scattered Data)After ( Collected Data)

Thanks in Advance.

[Nathaniel_C]

Hi @oabd0250 ,

If I understand the issue. You want to go from here to 

here.

Here is my pbix just go to table(2) and look at the steps.  Not sure how the is affected by a file in SharePoint.

Combine rows
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[oabd0250]

Hi Nathenial, 

Thank you so much for your quick reply, however what i`m trying to do is a bit more complicated, as my real table got completely messy by transposing the table , also splitting the column by delimiter after being merged together will get my data more messy,

what i`m trying to do.. is as follows
1- Keep only duplicated unique ID and remove the rest ( taking into consideration the refresh.. as some new data may make one of the old unique IDs dublicated )
2-Merge rows for the duplicated leaving only one row with all the information

So far thank you so much for your assistance.
Omar