Macro - Complex Concatenate

The data pull I receive on a month to month basis never has the columns in the same order.

I would like to know how to write a macro that will look for the columns I want to concatenate and then concatenate them in the first available column in my spreadsheet.

I have attached a spreadsheet where I would like the columns "Rate your experience?" and "On a scale of 0 to 10, how did it go?" to be concatenated into a new column, named "Rating - ALL".

I am new to macros and haven't got beyond recording a macro for a simple concatenate. So any help would be appreciated.