Spreadsheet: 207307d1358426497-combine-2-rows-of-data-if-conditions-are-met-example
Sheet: Sheet1

294 | Julian | LE17 4AP | PI | Solicitor | Fee Income GBP | 649145 |  | free1 | 236x | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 1000000 | AOC | costs in addition | 2000000 | AOC | 5000 | capped at 3 times |  |  |  |  |  |  |  |  |  | 3 | GBP | 4200 |  |  | 735 | 100 | 100 | GBP |  |  | Inter Hannover
295 | Julian | LE17 4AP | PI | Solicitor | Fee Income GBP | 649145 |  | primary1 | 236 | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 2000000 | AOC | costs in addition | 0 | AOC | 5000 | capped at 3 times |  |  |  |  |  |  |  |  |  | 3 | GBP | 32750 |  |  | 5817.22 | 100 | 100 | GBP | 3000000 |  | Inter Hannover
296 | Smith | CB10 1JD | PI | Solicitor | Fee Income GBP | 1266591 |  | primary1 | 237 | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 2000000 | AOC | costs in addition | 0 | AOC | 5000 | capped at 3 times |  |  |  |  |  |  |  |  |  | 3 | GBP | 29000 |  |  | 5151.13 | 100 | 100 | GBP |  |  | Inter Hannover
297 | Smith | CB10 1JD | PI | Solicitor | Fee Income GBP | 1266591 |  | free1 | 237x | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 3000000 | AOC | costs in addition | 2000000 | AOC | 5000 | capped at 3 times |  |  |  |  |  |  |  |  |  | 3 | GBP | 6000 |  |  | 1049.997469996458 | 100 | 100 | GBP |  |  | Inter Hannover
298 | [NAME] | M30 9ES | PI | Solicitor | Fee Income GBP | 321142 |  | primary1 | 238 | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 2000000 | AOC | costs in addition | 0 | AOC | 5000 | capped at 3 times |  |  |  |  |  |  |  |  |  | 1 | GBP | 12007 |  |  | 2132.74 | 100 | 100 | GBP |  |  | Inter Hannover
299 | [NAME] | M30 9ES | PI | Solicitor | Fee Income GBP | 321142 |  | free1 | 238x | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 3000000 | AOC | costs in addition | 2000000 | AOC | 5000 | capped at 3 times |  |  |  |  |  |  |  |  |  | 1 | GBP | 4218 |  |  | 738.1500000000001 | 100 | 100 | GBP |  |  | Inter Hannover
300 | Hemsley | CH1 4DR | PI | Solicitor | Fee Income GBP | 195050 |  | primary1 | 239 | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 2000000 | AOC | costs in addition | 0 | AOC | 2500 | AOC |  |  |  |  |  |  |  |  |  | 1 | GBP | 2500 |  |  | 444.06 | 100 | 100 | GBP |  |  | Inter Hannover
301 | Hentys | PO7 7AN | PI | Solicitor | Fee Income GBP | 159407 |  | primary2 | 240 | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 3000000 | AOC | costs in addition | 0 | AOC | 3500 | AOC |  |  |  |  |  |  |  |  |  | 2 | GBP | 7500 |  |  | 1332.19 | 100 | 100 | GBP |  |  | Inter Hannover
302 | [NAME] | E16 4HQ | PI | Solicitor | Fee Income GBP | 1000000 |  | primary2 | 241 | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 3000000 | AOC | costs in addition | 0 | AOC | 5000 | capped at 3 times |  |  |  |  |  |  |  |  |  | 4 | GBP | 30000 |  |  | 5328.75 | 100 | 100 | GBP |  |  | Inter Hannover
303 | Henriques | ME15 6GB | PI | Solicitor | Fee Income GBP | 400000 |  | primary1 | 242 | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 2000000 | AOC | costs in addition | 0 | AOC | 5000 | capped at 3 times |  |  |  |  |  |  |  |  |  | 2 | GBP | 11220 |  |  | 1992.95 | 100 | 100 | GBP |  |  | Inter Hannover
304 | Hewitson | CB5 8EP | PI | Solicitor | Fee Income GBP | 12714390 |  | primary2 | 243 | B0808612016 | Dec | 2012 | 2012-10-01 | 2013-09-30 |  | GBP | 3000000 | AOC | costs in addition | 0 | AOC | 100000 | other | capped 3 times |  |  |  |  |  |  |  |  | 40 | GBP | 168750 |  |  | 5484.38 | 100 | 100 | GBP |  |  | Inter Hannover