Parsing Multiple Columns to Rows

[RCurry1230]

Hello Brilliant People, I need to parse multiple columns to rows so that I have a combination of each code available in USSGL attribute table (this is public information).  I have a sample of what I'm trying to accomplish, which is a small portion of it, but I have a LOT of columns that I need to parse into rows which will take me a long time...wondering if there is a better solution. 

Data set (need to parse all the columns with arrows to rows):

Sample of what I need it to do: 

[TimothyH]

@RCurry1230  - I would say that if the process will remain static (always same columns to parse) then your original plan is the most resilient and easily documentable solution.  If it needed to be more dynamic, you could turn it into a macro to allow for different column names or delimiters.