You could have a calculation of some sort at the end of each row which concatenates all the rows with the separator of your choice.

Say you have the Bob, Jim, and Tom in Row 1, A through C:

will return Bob Jim Tom. Alternatively, you can use the CHAR function to insert something other than a space or just type something else in quotes that suits you. You'll have to experiment with what pastes and doesn't.