Parsing Multiple Columns to Rows

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:

Example output.png

Attribute Table.yxzp

Workflow

Parse

Help

Accepted answers

Qiu

@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.

1217-RCurry1230.yxzp

All comments

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

@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.

1217-RCurry1230.yxzp

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703