Forum Discussion
Collaborate two rows information into one and delete one
I have found a solution for this. Thanks,
Community ChampionWe'll need to know how to tell the difference between the two options
"because they are two different projects although the both projects have "C" in "project" column"
"For the last two rows, and this is my second example, since they are the same project,"
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.
I have found a solution for this. Thanks,