Highlight ALL the date you want to put into Excel. Go to Edit at top and
press copy. Then open Excel and when the page is open go to Edit and paste.
THEN
highlight the TOP row (I've found it works best when you do only one column
at a time) A[Your Title for the column here] B[col title] etc. Highlight
A then
go to Format and select AUTOMATIC FIT. Do this procedure for each column.
Then go to file SAVE AS.... give it a name... and there you are. If you
want lines in it
you will have to check the page set up and go to the tab after
headers/footers ... I've forgotten right off... but there's a place to check
if you want graph style line. Put a check in it. Exit SAVE then press
File /Print Setup to see if it is
the way you want it. If not, press File/Page Setup and change it to the way
you want it. HTH

Helen


"hugh jass" wrote in message
.. .
: Hello,
: I am trying to do a table summary, which I believe I can accomplish with
the
: Pivot Table Report.
: Can someone please help with what I am trying to do?
:
: Using the following table (figure 1) as an example (comma separated incase
: you'd like to copy the text, save as a .csv file, then import into Excel -
: didn't want to post any attachments), I would like to build a summary
based
: on specific columns.
: Essentially, I want the following information:
: Number of cars sold by Manufacturer, date and dealer, similar to below.
: manufacturer: Ford, date: 09/09/2003, dealer: 1, 1 cars sold
: manufacturer: Ford, date: 09/09/2003, dealer: 2, 1 cars sold
: manufacturer: Citroen, date: 08/09/2003, dealer: 1, 2 cars sold, etc...
: Can this be done in Excel?? If so, how do you do it? How do you deal
with
: the fact that this is not all numeric data?
: THanks in advance, hj.
:
:
: figure 1.
: Used Cars Recently Sold in Yourtown, OH.
: manufacturer,model,license,date,dealer
: Ford,Edsel,ewr-234,09/09/2003,1
: Ford,Focus,eru-743,09/09/2003,2
: Toyota,Landcruiser,itr-393,07/09/2003,3
: Toyota,Corona,ack-394,09/09/2003,3
: Toyota,Corona,krm-584,06/09/2003,2
: Citroen,DSpécial ,mfh-854,08/09/2003,2
: Citroen,Pallas,ner-936,08/09/2003,1
: Citroen,Pallas,mke-483,08/09/2003,1
: Honda,Civic,nkr-486,08/09/2003,2
: Honda,Civic,isk-438,07/09/2003,3
: Honda,Accord,wdl-348,07/09/2003,1
:
: ______________________
: "peace - it's worth killing for"
: - Bush
:
:
: