up vote 2 down vote favorite
share [g+] share [fb]

I'm new here and I hope to seek for your assistance on converting data format of my excel to csv.

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.

link|improve this question
1  
What is wrong with saving it as a .csv? – soandos Feb 8 at 8:37
Sorry, i didn't make my question clear. I mean I would want to convert the from multiple columns to single column with data separated by ";" – Seewhy Feb 8 at 9:03
I have changed the title, as it seems your objective is not to create a normal CSV file but to combine columns in Excel. If I misunderstand, please undo the change and/or update the question to clarify the objective. – RedGrittyBrick Feb 8 at 11:11
feedback

2 Answers

up vote 1 down vote

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.

link|improve this answer
feedback
up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.