I have multiple rows of data that I need to reformat to match another much larger spreadsheet's layout.
Sorry about all the dots, I don't know how else to somewhat display the data in columns
What I have is Total hours in Skill labor and a StartDate where I calculated the Duration from the EndDate:
ProjNum....StartDate....EndDate....Duration(Months)....Skill1....Skill2....Skill3.... etc...
123...........Aug2017.......Aug2017............1..........................12...........8..........45
456...........Sep2017.......Dec 2017...........4.........................100..........0.........200
789...........Sep2017.......Apr 2018............8.........................88............64.......128
What I need is (insert rows between Project Numbers, then skill divided by Duration and evenly disperse that in each date column starting on the StartDate for the Duration):
ProjNum....Skill....Aug17....Sep17....Oct17....Nov17....Dec17....Jan18....Feb18....Mar18.....etc....
123
................Skill1......12.........0...........
................Skill2.......8..........0...........
................Skill3.......45.........0..........
456
................Skill1.......0........25..........25........25...........25.........0.....
................Skill2.......0.........0............0..........0.............0..........0.....
................Skill3.......0........50..........50..........50...........50.........0....
789
................Skill1.......0.......11...........11.........11...........11.........11........11.........11....0
................Skill2.......0.......8.............8...........8.............8...........8..........8..........8....0
................Skill3.......0.......16..........16.........16...........16.........16........16.........16....0
Thanks,
Don
Sorry about all the dots, I don't know how else to somewhat display the data in columns
What I have is Total hours in Skill labor and a StartDate where I calculated the Duration from the EndDate:
ProjNum....StartDate....EndDate....Duration(Months)....Skill1....Skill2....Skill3.... etc...
123...........Aug2017.......Aug2017............1..........................12...........8..........45
456...........Sep2017.......Dec 2017...........4.........................100..........0.........200
789...........Sep2017.......Apr 2018............8.........................88............64.......128
What I need is (insert rows between Project Numbers, then skill divided by Duration and evenly disperse that in each date column starting on the StartDate for the Duration):
ProjNum....Skill....Aug17....Sep17....Oct17....Nov17....Dec17....Jan18....Feb18....Mar18.....etc....
123
................Skill1......12.........0...........
................Skill2.......8..........0...........
................Skill3.......45.........0..........
456
................Skill1.......0........25..........25........25...........25.........0.....
................Skill2.......0.........0............0..........0.............0..........0.....
................Skill3.......0........50..........50..........50...........50.........0....
789
................Skill1.......0.......11...........11.........11...........11.........11........11.........11....0
................Skill2.......0.......8.............8...........8.............8...........8..........8..........8....0
................Skill3.......0.......16..........16.........16...........16.........16........16.........16....0
Thanks,
Don