Spreadsheet: 695828d1600419586-convert-unstructured-column-base-data-into-single-row-excelforum-2-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Desired Result |  | [NAME] result
Name | Years |  |  |  |  |  |  |  |  |  | Year | Name | Year | Name
[NAME] | 2013-2015 |  |  |  |  |  |  |  |  |  | 2013 | [NAME]
Barb | 2015 |  |  |  |  |  |  |  |  |  | 2014 | [NAME]
[NAME] | 2000-2004 |  |  |  |  |  |  |  |  |  | 2015 | [NAME]
[NAME] | 2001-2006 |  |  |  |  |  |  |  |  |  | 2015 | Barb
[NAME] | 2012-2015 |  |  |  |  |  |  |  |  |  | 2000 | [NAME]
[NAME] | 2016-2017 |  |  |  |  |  |  |  |  |  | 2001 | [NAME]
[NAME] | 2005 |  |  |  |  |  |  |  |  |  | 2002 | [NAME]
Hank | 2002-2005 |  |  |  |  |  |  |  |  |  | 2003 | [NAME]
Ike | 2010 |  |  |  |  |  |  |  |  |  | 2004 | [NAME]
Jared | 2014-2018 |  |  |  |  |  |  |  |  |  | 2001 | [NAME]
Kelly | 2002-2006 |  |  |  |  |  |  |  |  |  | 2002 | [NAME]
[NAME] | 2001-2006 |  |  |  |  |  |  |  |  |  | 2003 | [NAME]
[NAME] | 2006-2011 |  |  |  |  |  |  |  |  |  | 2004 | [NAME]
Nan | 2009 |  |  |  |  |  |  |  |  |  | 2005 | [NAME]
Otto | 2002 |  |  |  |  |  |  |  |  |  | 2006 | [NAME]
[NAME] | 2015-2019 |  |  |  |  |  |  |  |  |  | 2012 | [NAME]
Quenten | 2010-2011 |  |  |  |  |  |  |  |  |  | 2013 | [NAME]
Raul | 2013-2016 |  |  |  |  |  |  |  |  |  | 2014 | [NAME]
[NAME] | 2013-2016 |  |  |  |  |  |  |  |  |  | 2015 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2016 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2017 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2005 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2002 | Hank
 |  |  |  |  |  |  |  |  |  |  | 2003 | Hank
 |  |  |  |  |  |  |  |  |  |  | 2004 | Hank
 |  |  |  |  |  |  |  |  |  |  | 2005 | Hank
 |  |  |  |  |  |  |  |  |  |  | 2010 | Ike
 |  |  |  |  |  |  |  |  |  |  | 2014 | Jared
 |  |  |  |  |  |  |  |  |  |  | 2015 | Jared
 |  |  |  |  |  |  |  |  |  |  | 2016 | Jared
 |  |  |  |  |  |  |  |  |  |  | 2017 | Jared
 |  |  |  |  |  |  |  |  |  |  | 2018 | Jared
 |  |  |  |  |  |  |  |  |  |  | 2002 | Kelly
 |  |  |  |  |  |  |  |  |  |  | 2003 | Kelly
 |  |  |  |  |  |  |  |  |  |  | 2004 | Kelly
 |  |  |  |  |  |  |  |  |  |  | 2005 | Kelly
 |  |  |  |  |  |  |  |  |  |  | 2006 | Kelly
 |  |  |  |  |  |  |  |  |  |  | 2001 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2002 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2003 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2004 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2005 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2006 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2006 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2007 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2008 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2009 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2010 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2011 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2009 | Nan
 |  |  |  |  |  |  |  |  |  |  | 2002 | Otto
 |  |  |  |  |  |  |  |  |  |  | 2015 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2016 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2017 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2018 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2019 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2010 | Quenten
 |  |  |  |  |  |  |  |  |  |  | 2011 | Quenten
 |  |  |  |  |  |  |  |  |  |  | 2013 | Raul
 |  |  |  |  |  |  |  |  |  |  | 2014 | Raul
 |  |  |  |  |  |  |  |  |  |  | 2015 | Raul
 |  |  |  |  |  |  |  |  |  |  | 2016 | Raul
 |  |  |  |  |  |  |  |  |  |  | 2013 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2014 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2015 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2016 | [NAME]