Index Match entire row descending order

[voltrader]

I have rows of data I am trying to Index Match variable amounts of dates from. I saw a blog mentioned descending order can extract the highest, then lowest matches. Table example:

Bob	None	1/1/2020	None	None	None	1/3/2020	None	None	None
Stanley	1/10/2020	None	None	None	None	None	None	None	None
Jim	None	None	None	11/7/2019	12/15/2019	None	None	None	None

I am trying to extract the date values as row entries to a different sheet like so :

Bob	1/1/2020
Bob	1/3/2020
Stanley	1/10/2020
Jim	11/7/2019
Jim	12/15/2019

I have already generated a list of names with duplicate name entries for multiple dates per name. I need to figure out how to extract the largest (or smallest) date, and drag down next largest (smallest) date for repeated name.

Thanks!

 

[Toadstool]

Toadstool,thanks so much this method works great!Tested it over the weekend and its awesome, I really appreciate the time you put into it!

You're welcome!
My insomnia thanks you for the thanks.