Transposing Data

[kolsby]

ID Charge# Resource 7/13/2008 7/20/2008
7/27/2008 8/3/2008
1 V/0153.01 .01.01.01 VSY4 35 32 16 19.75
2 V/0153.01 .01.01.01 VSY4 1 3 2 4
3 V/0153.01 .01.01.01 VSY4 12 4 1 3
4 V/0153.01 .01.01.01 VCEX 54 112 4 141
5 V/0153.01 .01.01.01 VME3 44 78 4 5


I have a table that i exported out of Microsoft project that has dates
by week for 3 years (~160 date fields).
When the data is in this format it becomes very difficult to do
anything in access as far as date filters or parameters. Is there a
way to transpose the data for all 160 date fields to look like the
following.

V/0153.01 .01.01.01 VSY4 7/13/08 35
V/0153.01 .01.01.01 VSY4 7/20/08
32
V/0153.01 .01.01.01 VSY4 7/27/08
16
etc...

Is there a good way to do this? I need to be able to compare a weekly
budget vs a weekly actual.
thanks,
KO

 

[Jeff Boyce]

If I recall, MS Excel has a "Transpose" function you could use to
pre-condition the data before importing into Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Pete D.]

Project can export in access format and can use many date formats in the
configuration. Have you tried exporting and changing options in project to
the many formats it can do. One of them should work. Pete