Hi

im trying to figure out VBA modlue code on how to merge cells based on duplicate cell data in rows.
The columns will not change, but rows & number of duplicates are unknown (sometimes 2 rows, sometimes 3+ rows & sometimes none)

column M N O P Q

Outermost Container
Length
Width
Height
Weight
c1
c2
c2
c2
c3
c3

would become

Outermost Container
Length
Width
Height
Weight
c1
(blank)
c2
(blank)
c3
(blank)


Capture.jpg

please could somebody help with this?