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