Convert Regular Excel file into csv file

[Guest]

I have a regular spreadsheet that is in column format. I want to collapse
the data into a csv sheet with all column collapsed into column A separated
by commas.

Is there any way that excel can do this? I tried to save as csv but it
still displayed as columns.

please help.

Thank you.

 

[David Biddulph]

A csv file is a text file with the variables separated by commas, and you
can read it with something like Notepad to confirm that it's done the right
thing. If you allow Excel to read the .csv file back in, it will (by
default) separate the variables into columns. If you rename (or copy) the
..csv file and call it a .txt file, then when you read it back in to Excel
you can change the options, and delete the selection of commas as field
delimiters.