View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark[_4_] Mark[_4_] is offline
external usenet poster
 
Posts: 7
Default Pivot Table? ID, Date, Value sorting

Hi
Excel 03
I'm wondering if a Pivot Table is the way to go.

I have data in this format
ID, Date, Value1, Value2, Value3, Value4, Value5

Each ID has Values by different dates usually a maximum of 5 dates. I want
the most recent Value by date for each ID from each column - Value1, Value2,
Value3 etc

For example, for ID 02 below would be as at 0712:
ID Date V1 V2 V3 V4 V5
02 0712 40 20 30 05 10

Now I need to extract this data to a spreadsheet to import into another
application

Many thanks
Mark

EG of data (BTW Values are percentages)

ID Date V1 V2 V3 V4 V5
01 0612 12 22 45
01 0712 14 40 22 50
02 0610 50 15 20 10 05
02 0612 45 30 05 10
02 0712 40 20 30 10
03 ...
03 ...
03...
03 ...
04...
04...
05...
05...
05...
etc to 600