I have an excel table with a string that I need to do the following
split L2Code
concatenate L3Code
have all the codes in a single column field
L3DescL3CodeL2CodeOMB_Flag30082001 ; 2002 ; 2003 ; 2004 ; 2005 ; 2006 ; 2007 ; 2008 ; 2009 ; 2017OMB_Flag30082010 ; 2011 ; 2012 ; 2013 ; 2014 ; 2015...