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.