LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding data from multiple rows PCStechnical Excel Worksheet Functions 2 October 11th 06 04:39 PM
Retrieve multiple data rows data from a very long list and copy t mathew Excel Discussion (Misc queries) 1 September 13th 06 08:24 PM
combining multiple rows of data into one single row of data myersjl Excel Worksheet Functions 0 March 30th 06 10:39 PM
Importing data from several fles with different subset of rows [email protected] Excel Discussion (Misc queries) 1 February 28th 06 05:23 PM
Importing Microsoft query data into excel changes linked rows Wazzy_bear Links and Linking in Excel 1 December 19th 05 09:09 AM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"