First Use of Excel Pivot Tables 1

[JohnBates]

hi all,

I have a database table which contains a date column and a column that contains a numerical value....only 1 record for each date:

(varchar) (smalldatetime) (Int)
DatabaseName Date Qty
Db1 3/1/2009 00:00:00 2501
Db1 4/1/2009 00:00:00 3722
Db2 3/1/2009 00:00:00 1488
Db2 4/1/2009 00:00:00 1754

one record for the 1st day of each month for each DatabaseName

I have pasted the above into an Excel worksheet.

but I want the quantities for each DatabaseName to be on the same line like this:

DatabaseName 3/1/2009 4/1/2009
Db1 2501 3722
Db2 1488 1754

** Is this a good use for Pivot tables - is that what I need to use ? **

Can anyone give me some tips for Excel 2003?

I actually have 12 months of figures. Just reduced it for this example.

Thanks very much.
John

 

[SkipVought]

Hi,

DatabaseName: ROW field
Date: COLUMN field
Qty: DATA Field

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlbo]

...and if you were in any doubt from Skips's eloquent answer ;-) - yes - this is a good use for pivot tables!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question