Need help with an Excel Macro

Hello,

I am new to creating Macros and would like to know if there is a way to write a macro to do the following.

I would type information into two columns in Excel as follows:

I would then run a macro to change these two columns to create a column like this:

Is this possible by using a macro?  Thank you.