Collaborate two rows information into one and delete one

Great......That is great question! I can provide more detail. 

I had two different excel spreadsheets to be appended in power query, both have one same column called "Project" and other different information (which was not on the screenshot). One excel provides "project" and "project description" columns. And the other provides "project" and "project initiative" columns. After appending both excels, I sorted by "project" then receive the sitation as on the screenshot. 

1st example - "to keep" 

Although both top two rows have "C" in the "project" column, there are two different names under "project initiative" column, therefore, two different projects. 

2nd example - "to collaborate"

After sorting the appended database by "project", I can see if any project appears in both excel spreadsheet and this is the case. When one project in both excels, then I will like to collaborate both excels. 

Just so you know, what you see is just snap shot of database, if possible, I would like to retain the original excel as it was given to me and manipulate all the changes in power query. Then I will be easiler to maintain the tool in the future. That is my original thought about this. Thanks, appreciated.