Excel VBA; Merging cells when criteria is met [Closed]

Report
-
Please I need help with the following,
how to merge cells if certain criteria is met. when prefixes in column A match, cells in column B will merge

A B A B
S125-1 APPLE S125-1
S125-2 APPLE = S125-2 APPLE
S125-3 APPLE S125-3
S125-4 APPLE S125-4

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!