I currently output an Access query to an Excel spreadsheet comprised of rows of two distinct data elements followed by seven repeating sets of three:
Resource ID|Project ID|Monday Date\Monday Hrs|Monday Cost|Tuesday Date\Tuesday Hrs|Tuesday Cost|Wenesday Date\Wednesday Hrs|Wednesday Cost|Thursday Date\Thursday Hrs|Thursday Cost|Friday Date\Friday Hrs|Friday Cost|Saturday Date\Saturday Hrs|Saturday Cost|Sunday Date\Sunday Hrs|Sunday Cost|
I need to reconfigure it to more “vertical” rows asfollows:
Resource ID|Project ID\Date|Hrs|Cost
Resource ID|Project ID\Date|Hrs|Cost
Resource ID|Project ID\Date|Hrs|Cost
