Combine data from multiple rows : <p>I have the following data in a sql server table:</p>

<hr>

<p><a href="https://i.stack.imgur.com/wgGQH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wgGQH.png" alt="enter image description here"></a></p>

<p>What I need is to combine these rows based on Bulletin_Number and Speed between the mile posts. I need the following output: </p>

<p><a href="https://i.stack.imgur.com/GW6zC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GW6zC.png" alt="enter image description here"></a></p>

<p>How can I do this in SQL Server?</p>
