Merging columns in Excel with ";" separator

This is my raw data in excel in different row and cells:

A   B   C   D   E   F
1   2   3   4   5   6
2   3   4   5   6   7
3   4   5   6   7   8

I would like to convert all data into this format containing 1 column and different rows:

A;B;C;D;E;F
1;2;3;4;5
2;3;4;5;6
3;4;5;6;7

As I have large volume of data to be processed, a convenient way of converting the data is really needed.

You can use this formula to merge one row to only one column:

= A1 & ";" & B1 & ";" & C1

Then, copy this formula to all rows and use the column you created where you want.

You can use the concatenate function =concatenate(A1,";",B1,";",C1 ... you then drag it down the entire height of your data. Once you've done this you copy and paste special - values to keep only the concatenated values. You can then delete everything except your pasted column and save as .csv

In excel there is a function called TEXTJOIN. It joins texts from multiple columns using user-provided delimiter.

It requires three parameters:

1. delimiter: what delimiter to use. In your case, it is ";"
2. ignore empty cells: true(ignores empty cells) or false(doesn't ignore)

3. text: you can provide range. e.g. A1:A6 in your case.

   =TEXTJOIN(";",FALSE,A1:A6)
   

Then you can drag the formula to copy the same in multiple rows and then copy and paste it as Values.

Hope it helps. BTW I am using Excel 2016, I dunno if this function is available in older versions..

Cheers.