Dear Statalists,

I have one simple question. At the moment, I am dealing with the data which is relatively cross-sectional. Please check the data as shown below:
Director Name Company ID Director_StartYear Director_EndYear
John 7 01/07/1996 01/07/2002
Mary 3 01/07/1999 01/07/2003
where Company ID is the unique identifier of the company, Director_StartYear is the beginning year of being the director of the company, and Director_EndYear is the ending year of being the director of the company.


Ideally, I would like to reshape it to the data format (to panel data) as:
Director Company ID Director_Year
John 7 1996
John 7 1997
John 7 1998
John 7 1999
John 7 2000
John 7 2001
John 7 2002
Mary 3 1999
Mary 3 2000
Mary 3 2001
Mary 3 2002
Mary 3 2003
Could you please kindly show me the possible stata code for doing this data transmission? Will "reshape" be a possible code?

Many thanks.

Best wishes,
Cong