Moving data from multiple cells to a new cell

Attached is a sample file. I'm dealing with 1,000+ records but I'm only sending over 5. I've stripped out a lot of data that doesn't apply to my original question.

I can (and have been) just copying and pasting the answers into the new column, however it is quite time consuming and if there is a way to do this automatically that would be preferred.

Hope this clears up the question, thanks.