VBA Excel to Group data by Name : <p>I'm not sure if this is possible with VBA.</p>

<p>I have this Data not in group: <br>
<a href="https://i.stack.imgur.com/0YSpI.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0YSpI.jpg" alt="Original Excel Table"></a></p>

<p>I need it to look like the following with "Module" grouped into Module 1,2,3, etc. and background color for the group: <br>
<a href="https://i.stack.imgur.com/sxuBl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sxuBl.jpg" alt="enter image description here"></a>
Please assist me with this in VBA. </p>

<p>Thank you very much!</p>
