Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding data from multiple rows | Excel Worksheet Functions | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
Importing data from several fles with different subset of rows | Excel Discussion (Misc queries) | |||
Importing Microsoft query data into excel changes linked rows | Links and Linking in Excel |