Hi xace

I can write Code that'll work on your Sample File but it'll be based on the Contents of Column A. I'm fairly confident that your Actual Data does not look like your Sample Data where Apple is in each Cell under Apple, Pear is in each Cell under Pear, etc.

What does your actual Data look like?

Row\Col
A
23
 Apple
24
 Apple1
25
 Apple2
26
 Apple3
27
 Apple4
28
 Apple5
29
 Apple6
30
 Apple7
31
 Apple8
32
 Apple9
33
 Apple10
34
 Apple11
35
 Pear
36
 Pear1
37
 Pear2
38
 Pear3
39
 Pear4
40
 Pear5
41
 Pear6
42
 Pear7
43
 Pear8
44
 Pear9
45
 Pear10
46
 Pear11
47
 Pear12
48
 Pear13
49
 Pear14
50
 Pear15
51
 Pear16
52
 Pear17
53
 Pear18
54
 Orange
55
 Orange1
56
 Orange2
57
 Orange3
58
 Orange4
59
 Orange5
60
 Orange6
61
 Orange7
62
 Orange8
63
 Orange9