Are you looking to concatenate all values within 123 columns into one cell ?

What are the lengths of the strings in each cell ?

How many rows in each column ?

Are there blanks interspersed amongst the data set - if so are they to be included in the output or simply ignored ?

Post a sample file which reflects your real requirements - ie a more thorough data set, also be sure to display desired output.

"Dumbing Down" the example from real scenario is unlikely to prove beneficial in this instance...