Paste data from one column to another

[Syndicate_Admin]

Good morning

I want to pass data from one column to another column to be one, but I have not found the way or function to do it,

What I need is for the WTG and WTG_1 columns to be one, for the values in the column to WTG_1 replace the null values.

I hope you can help me

Best regards

[Syndicate_Admin]

Good morning.

I used your proposal, but I get the next problem, the first 8 data in column WTG_1 are lied to and only added from row 9 onwards.

Best regards

[rsbin]

@Syndicate_Admin 
Good Morning.  I don't understand what you mean when you say "lied to".

To ensure your syntax is correct, you can use the "Conditional Column" icon in the Add Column menu

Regards,

[rsbin]

@Syndicate_Admin ,

Create a Custom Column, called something like WTG_Final using the Power Query IF function:

           if [WTG] = null
            then [WTG_1]
            else [WTG]

Hope this works for you.

Regards,