There is one way without a macro, look at the attachment, sheet 'Sheet 2'.
There is a formula there, but with semicolons, because in the 'G' column you use commas as inserts, not separators.
A comma is normally used as a column separator. You must decide on some separator.
1. Copy the formula to as many rows as you need
2. Select the data and choose the copy option and simply copy it
3. Create an empty text file ('.txt') on the disk in any location
4. Paste the copied data
5. Choose File => Save As => Encoding = Unicode / UTF-8
6. Save = > Ok
7. Change the file extension '.txt' to '.csv'
Bookmarks