Comma Separated List

Hi Holly,

In CSV (Comma Separated Values or, more generally, Character Separated Values) files, each value in a row is separated from the next with a comma (or other character named as the delimiter), and each row is separated from the next with a carriage return.

If you want your list to be displayed horizontally, you need to place the values in a row.

Examples:

The Numbers file was created as a single table file using the format shown as CSV sample 1, then exported to a csv file using that name.

The menu Table menu item Transpose Rows and Columns was then used to re-order the table to the format shown on the right, and the (still single table) document was again exported to a csv file with the name CSV sample 2.

I then duplicated the single table, repeated the Transpose Rows and Columns command on one of the two copies, named the two tables to match the name of the corresponding file, and arranged them as shown for the screen shot above.

Below are screen shots of the two sample files opened in TextEdit, and in Numbers.

TextEdit

Numbers:

Regards,

Barry

Hi Holly,

Is this what you are looking for?

quinn

Hi Holly,

TextEdit should do it. There will be a linefeed for each new row.

quinn