Best technique to convert to panel data
<p>I have some returns data on 1000+ firms that I want to convert into panel form.</p>

<p>From my understanding, it is neither truly wide nor long form (at least from the examples I've seen).</p>

<p>I have attached an example of the original data set and what I want it to look like. Is there a way to achieve this? I am intermediate with Excel/VBA, and new to SAS/Stata but can use them and self-teach myself. </p>

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