Spreadsheet: 862415d1710159669-splitting-rows-of-data-based-on-one-specific-weekly-figure-10-columns-x52-wks-monthly-report-split
Sheet: Sheet1

example |  | Service Structure3 | County4 | Client Name (Work Site) | Client TSS ID | Grade5 | Roll | Week 1 Total Net Hours | Week 1 Total of Basic Hourly Pay | Week 1 Agency Fee Percentage | Week 1 Total Agency Fee | Week 2 Total Net Hours | Week 2Total of Basic Hourly Pay | Week 2 Agency Fee Percentage | Week 2 Total Agency Fee | Week 3 Total Net Hours | Week 3 Total of Basic Hourly Pay | Week 3 Agency Fee Percentage | Week 3 Total Agency Fee
1 |  | Private | Dublin | Sprockets galore | 12456 | 3029 | [NAME] | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.085 | 17 | 10 | 20 | 0.2 | 40
2 |  | Private | Dublin | Sprockets galore | 12456 | 3088 | IT tecnitian | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.085 | 17 | 10 | 20 | 0.085 | 17
3 |  | Private | Dublin | Sprockets galore | 12456 | 3072 | Engineer | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
4 |  | Private | Cork | Cogs plus | 12884 | 1488 | Director | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
5 |  | Private | Cork | Cogs plus | 12884 | 3029 | [NAME] | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
6 |  | Chairity | Dublin | Cats homes | 13910 | 3029 | [NAME] | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.2 | 40
7 |  | Public | Dublin | Public Serice | 11851 | 3182 | Oversight | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
8 |  | Chairity | Wicklow | Dogs health | 12358 | 1882 | Secretary | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
9 |  | Priavte | Dublin | Tavel Global | 13332 | 3088 | IT tecnitian | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.085 | 17 | 10 | 20 | 0.085 | 17
 |  | What I need the end result to be
 |  | Service Structure3 | County4 | Client Name (Work Site) | Client TSS ID | Grade5 | Roll | Week 1 Total Net Hours | Week 1 Total of Basic Hourly Pay | Week 1 Agency Fee Percentage | Week 1 Total Agency Fee | Week 2 Total Net Hours | Week 2Total of Basic Hourly Pay | Week 2 Agency Fee Percentage | Week 2 Total Agency Fee | Week 3 Total Net Hours | Week 3 Total of Basic Hourly Pay | Week 3 Agency Fee Percentage | Week 3 Total Agency Fee
1 |  | Private | Dublin | Sprockets galore | 12456 | 3029 | [NAME] | 10 | 20 | 0.095 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 |  | Private | Dublin | Sprockets galore | 12456 | 3029 | [NAME] | 0 | 0 | 0 | 0 | 10 | 20 | 0.085 | 17 | 0 | 0 | 0 | 0
1 |  | Private | Dublin | Sprockets galore | 12456 | 3029 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 20 | 0.2 | 40
2 |  | Private | Dublin | Sprockets galore | 12456 | 3088 | IT tecnitian | 10 | 20 | 0.095 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  | Private | Dublin | Sprockets galore | 12456 | 3088 | IT tecnitian | 0 | 0 | 0 | 0 | 10 | 20 | 0.085 | 17 | 10 | 20 | 0.085 | 17
3 |  | Private | Dublin | Sprockets galore | 12456 | 3072 | Engineer | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
4 |  | Private | Cork | Cogs plus | 12884 | 1488 | Director | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
5 |  | Private | Cork | Cogs plus | 12884 | 3029 | [NAME] | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
6 |  | Chairity | Dublin | Cats homes | 13910 | 3029 | [NAME] | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 0 | 0 | 0 | 0
6 |  | Chairity | Dublin | Cats homes | 13910 | 3029 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 20 | 0.2 | 40
7 |  | Public | Dublin | Public Serice | 11851 | 3182 | Oversight | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
8 |  | Chairity | Wicklow | Dogs health | 12358 | 1882 | Secretary | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19 | 10 | 20 | 0.095 | 19
9 |  | Priavte | Dublin | Tavel Global | 13332 | 3088 | IT tecnitian | 10 | 20 | 0.095 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 |  | Priavte | Dublin | Tavel Global | 13332 | 3088 | IT tecnitian | 0 | 0 | 0 | 0 | 10 | 20 | 0.085 | 17 | 10 | 20 | 0.085 | 17