Spreadsheet: 88993d1288795705-recognise-change-in-pattern-and-create-a-space-insert-row-without-code
Sheet: Sheet1

Name | Number |  | Rep |  |  | Doc#
 |  |  |  |  |  |  | sort by | <   put a title here
687010 FEDERATED CO-OP | 981050504 |  | 362 | 30 | A | 981041285496 | 1 | <  enter 1 here
687010 FEDERATED CO-OP | 981050504 |  | 362 | 30 | A | [PHONE]-1 | 1 | <formula here is =IF(A4=A3,H3,H3+1)
687010 FEDERATED CO-OP | 981050504 |  | 362 | 30 | A |  | 1 | drag down to last entry in col a
752810 MEETAH BLDG SUPPLIES | 981052414 |  | 367 | 30 | A | 981042370077 | 2 | V
752810 MEETAH BLDG SUPPLIES | 981052414 |  | 367 | 30 | A | 981042370381 | 2 | V
752810 MEETAH BLDG SUPPLIES | 981052414 |  | 367 | 30 | A |  | 2 | V
A & C BLACKSMITH LTD | 981016887 | 1 | 358 | 30 | A | 981041286309 | 3 | V
A & C BLACKSMITH LTD | 981016887 | 1 | 358 | 30 | A |  | 3 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981041276214 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981046181953 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981041278979 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981046182752 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981046183705 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981041280624 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981046184044 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981041280926 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981041281067 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981041281069 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981046184503 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A | 981041284117 | 4 | V
A & R HOLDINGS | 981043130 | 1 | 358 | 30 | A |  | 4 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042356021 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042360479 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042361103 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042361180 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042362198 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981044245802 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042363739 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042364109 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042364158 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042364324 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042364570 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042365028 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042365234 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042365881 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042367592 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042368611 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042368757 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042369014 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042369828 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042369877 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042369997 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042370006 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042370080 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981044250842 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A | 981042370611 | 5 | V
A & W REST (SKTN, LLOYD,VICTO | 981018279 | 1 | 42 | 30 | A |  | 5 | V
A BRUSH ABOVE | 981030483 | 1 | 47 | 30 | A | 981047190362 | 6 | V
A BRUSH ABOVE | 981030483 | 1 | 47 | 30 | A |  | 6 | V
A G V L INTERIORS LTD | 981018277 | 1 | 364 | 90 | A | 981044243204 | 7 | V
A G V L INTERIORS LTD | 981018277 | 1 | 364 | 90 | A | 981044243288 | 7 | V
A G V L INTERIORS LTD | 981018277 | 1 | 364 | 90 | A | 981042358657 | 7 | V
A G V L INTERIORS LTD | 981018277 | 1 | 364 | 90 | A | 981044243452 | 7 | V
A G V L INTERIORS LTD | 981018277 | 1 | 364 | 90 | A | 981042358911 | 7 | V
A G V L INTERIORS LTD | 981018277 | 1 | 364 | 90 | A | 981044243502 | 7 | V
A G V L INTERIORS LTD | 981018277 | 1 | 364 | 90 | A | 981044243668 | 7 | V
A G V L INTERIORS LTD | 981018277 | 1 | 364 | 90 | A | 981044243723 | 7 | < fill of formula ends here
 |  |  |  |  |  |  | 1 | now number down until value = value of formula fill
 |  |  |  |  |  |  | 2 | V
 |  |  |  |  |  |  | 3 | V
 |  |  |  |  |  |  | 4 | V
 |  |  |  |  |  |  | 5 | V
 |  |  |  |  |  |  | 6 | V
 |  |  |  |  |  |  | 7 | V
 |  |  |  |  |  |  |  | STOP
 |  |  |  |  |  |  |  | NOW SELECT
 |  |  |  |  |  |  |  | A2 through to H66
 |  |  |  |  |  |  |  | then data /sort /has header row
 |  |  |  |  |  |  |  | pick the sort by header
 |  |  |  |  |  |  |  | sort
 |  |  |  |  |  |  |  | once done delete contents of col H