I have data that looks like this:

company name title
address city state zip

each piece of data occupys it's own cell

I would like to copy the data so it looks like this
company name title address city state zip

so the data all appears in one row.

Thank you for your help!