Excel horiz to vertical w/2 col repeated - TechRepublic
General discussion
December 11, 2000 at 07:18 AM
ctcarroll

Excel horiz to vertical w/2 col repeated

by ctcarroll . Updated 25 years, 6 months ago

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

This discussion is locked

All Comments