Help with pivot table

[tcrawfordoh]

I have a set of data that is dates across the columns, and two rows for each resource (1 for project and 1 for cost). I need to sum the cost for each project across all the resources. Any suggestions on how to organize the data so that I can create this report or pivot table? I have over a hundred resources so manipulating the data by hand takes too long. Thanks!

 

[Fazza]

hi,

Change the data to fields such as : resource, category (project or cost), date, value (or whatever you're measuring).

regards