Forum Discussion
Merged Several Excel file to replace null value in a column with value from other file.
Hello guys, I have several Excel files that have the same information, and I will merge them using Power Query. Situation: our system has automated sales reports daily. However, sometimes whe...
JohnGor_Gor this, i beleieve could be done by appending queries, Remove nulls from date column after appending might do the trick.
Thanks for the answer, but then there are 2 "Marry" rows. How can it also be done in Power Query without going back to Excel to clear duplicate value?
if i am understanding this correctly, you could shift + select all columns that might be exact duplicates (in above example column A + B + C) and righclick select remove duplicates will return unique values from each of those columns.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.