How to combine data from multiple columns into one in Excel?

Question

excel

There is a table in which there are 10 columns... there are many lines with text under each column (a lot).
I need to make it so that all the values ​​from each column of each row are merged into one column.

Answer 1

I didn’t quite understand the question, but if you need to combine A2 + B2 + C2 + ... + J2, then you can do this
or
where instead of a space, in quotation marks, enter any separator, or nothing (if you just need to combine strings together).

Answer 2

times
www.planetaexcel.ru/plex
two
csved.sjfrancke.nl