How to convert multiple rows into single row in excel?
<p>I have data in table as below:</p>

<p><a href="https://i.stack.imgur.com/oOQZl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oOQZl.png" alt="pre"></a></p>

<p>I have data as above in table. This table has many MMID M000071,M000073,....etc. screeningterm might vary for assets. Every MMID may have several dates. </p>

<p>I want output as below:</p>

<p><a href="https://i.stack.imgur.com/R8HGA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/R8HGA.png" alt="after"></a></p>

<p>There are 20 thousands in the table. So I want to find an easy way to do this job.</p>