Macro to combine date and time column

[tsherv]

Hi,

I have a spreadsheet that is generated from my ERP that has a date in column F and a time in column G. I need to create a macro that would combine both columns into one column (to the bottom of the range) and then delete one of the columns so there is only 1 date / time column.

Any ideas how to do this?

Thanks.

 

[Misca]

Try using Power Query. It used to be a free Excel Add In in the older versions but changes are you can already find it under the name "Get & Transform" from the Data tab of your current Excel.

YouTube is filled with all kinds of Power Query tutorials. You might want to spend a few minutes watching those to get you started but the main trick you're going to have to do is first to make sure your columns are datatypes date (date column) and time (time column). Once you've done that select both columns and use the Combine Date and Time found under the Date button on the Transform tab. Make sure to convert the combined column as Date / Time datatype before loading your query to your new table (I'm guessing that's what you want to do).

 

[tsherv]

Is there any other way to combine date and time fields where it could be accomplished through a macro?