Hello!

I have combined the data from five columns into one column using:

=CONCATENATE(H2,I2,J2,K2,L2)

Now I want to copy the resulting data into a new column. After it is copied into the new column, I want to delete the five columns and the concatenate column, so I'm just left with the results.

Could someone explain how to go about doing this?

Thank you!