Importing data into multiple rows

[Orlando2007]

I need to create a template to import data automatically into multiple rows,
so I do not have to format it each time after importing. I have created a SQL
query to create a CSV file with all the data. There is one record per row,
but I'd like to each record displayed in 3 rows. Can someone please help!!!!

As an example, the data being imported is "Name", "Address", "City",
"State", "Total Price", "Price per item" "Number of Items" and I would like
to view it as
"Name"
"Address" "Total Price"
"City" "Price Per Item"
"State" "Number of Items"

 

[Joel]

You may need to modify your CSV file.

A semicolon indicates the string goes on the same row in the excel worksheet.
If you want the datta on seperate rows, the put a carrriage return into the
SQL routine instead of a semicolon.

 

[Orlando2007]

Is that the only way to do this? Also, does anyone know how to retain the
formatting for "merged" cells when importing data? All other formatting
appears to stay as is except all merged cells unmerge.