Col.1 Col.2
name1 | n1
name2 | n2-1, n2-2
name3 | n3
If I save it in CSV-format, it looks as follow when I open it in txt-editor:
name1;n1
name2;n2-1,n2-2
name3;n3
Now I want to save the sheet in the following format:
n1;n2-1,n2-2;n3
or:
n1;n2-1,n2-2;n3;
That means, the first colume must be taken off and the data follows line by line and devided by a semi-colume.
How can I write a makro in Excel?