How do I import external data and create two formats?

G

Guest

I want to import external data with two types of rows. On the top should be
a title
with different widths, and on the bottom will be the data. Both of these
types of data are coming from the same external source. I am using excel
2003. Thanks!
Example:
Quicksilver Oil Company
Well Name

Data Data Data
..01 .01 .01
..02 .02 .02
 
G

Guest

the best way is tto generate the data with commas between fields. The comma
tells excel to put the data in the next column. Putting two comma together
like 12,,13 tells excel to put 12 in column A and 13 in column C. then call
the file with a .CSV extension.

Excel will open .CSV files automatically. Also you can Import CSV files
into other workbooks use the Data - Import feature.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart and date data 2
Pivot Table - How Do I Convert Data? 1
Combine two sets of overlapping Date/Time data into 3 columns. 3
Difficult Two Column Lookup 2
Concatenating two variable fields into a static length text field 2
data extract 7
I want to count the total Number of dates between two dates How? 3
how do I compare two dates? 3

Top