Merged Several Excel file to replace null value in a column with value from other file.

[JohnGor_Gor]

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 when we retrieve the data, the "Date column" information may disappear in one day file while it appears in the previous day. So, I am wondering how can I replace the null value in one excel file while filling in the null value from the other/another excel file.

Here is the simple sample:

Desirable outcome:

[BiAnalyst]

@JohnGor_Gor  this, i beleieve could be done by appending queries, Remove nulls from date column after appending might do the trick.

[JohnGor_Gor]

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?

[BiAnalyst]

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.