How to merge rows in excel?

[ukki]

Hello,

I need to meger multiple rows to 1 row, and need to separe each data with ALT+ENTER.
I need to do this for 75000 rows, so not possible to do manually. I heard we can use macro for this. Any suggestions plz?

Example:

Before:
Row1: test
Row2: test1
Row3: test2

After:
Row1:
test
test1
test2

thanks for help.

[fleury]

When you say that you have 75000 rows, do you mean that you are trying to fit that many lines of text into a single cell? (If so, this solution will not work). Or, do you mean that you have to do this sort of process with 75K examples?

If it's the latter, you can do something like this:

=CONCATENATE(A1, CHAR(10), A2, CHAR(10), A3, CHAR(10))

the "CHAR(10)" is a carriage return, which creates a new line. This will only work if you put this formula in a cell that has "Wrap Text" turned on.


--
Marc.

[ukki]

I have to do this sort of process with 75K examples. Thanks for CONCATENATE solution.
But the row numbers are not fixed, and vary from 3-10 for different examples. Not sure if some macro can run on all rows, so that I dont have to run it manually for all 75k examples.

Attaching a file for example.