Inserting a Merged Row after a certain text is found in a table

[Snaybot]

I have a 6 Column Table

With the First Column a automatic numbering format

So the first column farthest to the left is 4.1.1, 4.1.2, 4.1.3, ect ect

And the second column (Second from the left) is formatted such as "Ensure SXXXXX" (Where X is a number 1-9999)

I want to write a macro where if there is a value of "Ensure S" then add a Grey colored Merged Row spanning all 6 columns with the Value of "Step SXXXXX"


Is this possible?

Image attached



This is what I want the macro to do... Im ok at excel vba but I have no idea what to do here