How to combine multiple column values into 1?

[deanhystad]

Your file is not CSV because it does not consistently use the same character as a delimiter. Your file sometimes uses commas as a delimiter, but other times commas are just part of a string. You can include the delimiter in a string, but the string has to be quoted.

Another problem with your file is is doesn't have a tabular format. Sometimes a line is a new row, other times it is a continuation of the previous row. I think this can also be fixed by quoting the string.

My guess is your file is a botched attempt at making a CSV format file. It is easy to botch writing a CSV file. Really easy.