Cyberbeing
New Member
- Joined
- Apr 3, 2013
- Messages
- 5
Hello
Can someone please help with this?
I make a Manpower Plan like this.
<tbody>
</tbody>
I like to convert it automatically to this.
<tbody>
</tbody>
Could you tell me how to do it.
I am thankful for all help.
Regards
Can someone please help with this?
I make a Manpower Plan like this.
MANPOWER PLAN | |||||||
NAME | 1-Apr | 2-Apr | 3-Apr | 4-Apr | 5-Apr | 6-Apr | 7-Apr |
NAME1 | AM | PM | NIGHT | OFF | AM | PM | NIGHT |
NAME2 | OFF | AM | PM | NIGHT | OFF | AM | PM |
NAME3 | NIGHT | OFF | AM | PM | NIGHT | OFF | AM |
NAME4 | PM | NIGHT | OFF | AM | PM | NIGHT | OFF |
NAME5 | AM | PM | NIGHT | OFF | AM | PM | NIGHT |
NAME6 | OFF | AM | PM | NIGHT | OFF | AM | PM |
NAME7 | NIGHT | OFF | AM | PM | NIGHT | OFF | AM |
NAME8 | PM | NIGHT | OFF | AM | PM | NIGHT | OFF |
<tbody>
</tbody>
I like to convert it automatically to this.
SCHEDULE | ||||||
1-Apr | 2-Apr | 3-Apr | 4-Apr | 5-Apr | 6-Apr | 7-Apr |
AM | ||||||
NAME1 | NAME2 | NAME3 | NAME4 | NAME1 | NAME2 | NAME3 |
NAME5 | NAME6 | NAME7 | NAME8 | NAME5 | NAME6 | NAME7 |
PM | ||||||
NAME4 | NAME1 | NAME2 | NAME3 | NAME4 | NAME1 | NAME2 |
NAME8 | NAME5 | NAME6 | NAME7 | NAME8 | NAME5 | NAME6 |
NIGHT | ||||||
NAME3 | NAME4 | NAME1 | NAME2 | NAME3 | NAME4 | NAME1 |
NAME7 | NAME8 | NAME5 | NAME6 | NAME7 | NAME8 | NAME5 |
OFF | ||||||
NAME2 | NAME3 | NAME4 | NAME1 | NAME2 | NAME3 | NAME4 |
NAME6 | NAME7 | NAME8 | NAME5 | NAME6 | NAME7 | NAME8 |
<tbody>
</tbody>
Could you tell me how to do it.
I am thankful for all help.
Regards