Power Query function SE

0

I have a file that I need and I need to put a new column. This new column should bring in front of a certain value the amount as explained below. These values are in two existing columns. Ex:

1           2
null        13:00
13:30       13:35
null        14:00
14:30       14:35
null        15:00
15:30       15:35
null        16:00
null        16:35

When column 1 is null bring column 2 when there is value in column 1 bring column 1.

I'm currently using the excel SE in the original file and then dealing with Power Query.

What I would like to do is download the file and treat it directly in Power Query without having to use the SE in excel, since when there are updates I can do it just by replacing the file.

    
asked by anonymous 01.07.2018 / 14:42

0 answers