Hello everyone,

I have a dataset containing data about Board Members and it is formatted like this:
Name Start Date End Date Role Name Ticker
Mr. Jan Appels 21-03-2010 31-12-2010 Board member AED
Mr. Jan Appels 01-01-2011 20-11-2018 CEO AED
My question is: Is there a way to combine these two observations into one which contains the first start date and the latest end date based on Name and Ticker, where Role Name could be dropped as it is not a useful variable for my research. So the data would then look like:
Name Start Date End Date Ticker
Mr. Jan Appels 21-03-2010 20-11-2018 AED
I've tried several things but without success, hopefully, someone can help me.
Thanks in advance.

Regards,
Roel