View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Orlando2007 Orlando2007 is offline
external usenet poster
 
Posts: 2
Default Importing data into multiple rows

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"
--
Orlando2007