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.  

[RCurry1230]

Thanks Alex. It will remain the same for the year, and Treasury doesn't change much YoY. I might try to do a macro for my own sake/learning, but I'll continue on my current path. 

[Qiu · Accepted solution]

@RCurry1230 
Maybe there is a better way, but given that you column number is not fixed and try to be dynamic.

I use an iterative macro to keep append the columns.

[Qiu]

@RCurry1230 
I am thinking to submit this one as a weekly challenge idea.
What do you think?

[RCurry1230]

This is PERFECT! I just posted another question on this just a second ago, but I'm wondering if this will work too. I hate that this notification gets caught in my spam folder, so mad I missed it when it came in. 

[RCurry1230]

I think it's an awesome idea! Sometimes I think my issues are not most people's issues, but this is going to help me so much.