Replace a null value with the value from the column of the left

[ceov95]

So I have this data and I have some null values that doesn't work for me, and I need to replace them with the value from the left column, do you know if it's possible?

This is the snapshot of the data I have:

So for example second row in "abril-2020" I'd need to have the second row value from "marzo-2020".

Thanks in advance.

[camargos88]

Hi @ceov95 ,

You can unpivot the date columns and fill down/up.

[ceov95]

Yes, the thing is in the previous step I had it unpivoted but as this Item Code didn't any movement during april the database table didn't save the record for that month, here I attach a snapshot of the data before the unpivot:

So when I unpivot the the table, and because other Item Codes have had any movement during april it shows me the null value.

[mahoneypat · Accepted solution]

To avoid that issue, before you unpivot, you can replace all the nulls with a value you'll replace back with null later.  Highlight all your columns to unpivot and replace values, replacing "null" with 9999999 or something like that.  You then unpivot and then replace the 9999999 with null, fill down, etc.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat