How to create column based on content of other columns

[walterdp]

Hi all:

I have a table with a column with missing data. I want to fill that missing data based on what other columns have.

Let me explain. Here's in the example below, the column "Producto cat 2" has missing information. 

I can infer what should be there based on the other 2 columns. For instance, if in column "Resumen" appears "soporte en correo corporativo...", then missing data  in column "Producto" would be "CORREO". If column "Resumen" has "soporte estación de trabajo" then missing data would be "ESTACION DE TRABAJO", but if in column "Grupo Resolutor" data is "WMOS" then missing data would be "WMOS".

So, in the end, this should be like

Any help would be really appreciated!

Thanks in advance.

Walter 

[walterdp]

Hi, @johnt75 

I've tried that but didn't work:

when leaving field blank

when using "" 

[johnt75 · Accepted solution]

The only other thing I can suggest is changing the type of the Producto cat 2 column to text before you create the new conditional column.

[walterdp]

Thanks, @johnt75 . Now it does work!

[walterdp]

Hi, @johnt75 

Thanks for replying. I've tried what I understood your idea was, but it seems it did not work. Here is the configuration of the conditional column

And here's the result: new column "Producto" with same data as "Producto cat 2"

Am I missing something?

Thanks

[johnt75]

It looks like in the original column the value is not null but actually has something in it, either the empty string or possibly a space or something. Instead of putting null in the first condition just leave that box empty

[johnt75]

Create a new conditional column in Power Query. The first condition would be if Producto cat 2 is not null then use that value, then add your additional conditions.

Finally you can delete the original column and rename the new column appropriately