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: 414
Default privot table help

If i have info in the form of this:

date total date reg date irreg
06/06/08 1.50 06/06/08 1.50 07/06/08 4.50
07/06/08 4.50 09/06/08 4.50 09/06/08 8.00
09/06/08 12.50 10/06/08 8.00 13/06/08 3.50
10/06/08 8.00 11/06/08 4.50 15/06/08 10.75
11/06/08 4.50 13/06/08 2.00 16/06/08 8.00
13/06/08 5.50 19/06/08 8.00 19/06/08 11.00
15/06/08 10.75
16/06/08 8.00
19/06/08 19.00


How do i put this into 1 pivot table so i get:
date total reg irreg
xxx xx xx xx
xxx xx xx xx


 
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
Excel 2007 Macro specific table to generic table? Sue Excel Discussion (Misc queries) 3 June 1st 08 06:12 PM
Pivit table- cell on spread sheet referencing pivot table field David M Charts and Charting in Excel 2 August 18th 07 07:46 PM
entry removed from source table remains in pivot table pull down EL in Melb. Excel Worksheet Functions 1 September 6th 06 07:59 AM
Excel Pivot Table Plugin? (crosstab to data table) HoMoon115 Excel Discussion (Misc queries) 0 February 22nd 06 08:20 PM
PIVOT TABLE - Summary Table into a Databasae Table. sansk_23 Excel Worksheet Functions 4 May 9th 05 07:45 AM


All times are GMT +1. The time now is 11:50 AM.

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"