HELP NEED BEGINNER REQUEST

[HOUEW]

Hello, I am trying to get a desired output, but I am using too many basic steps. Can anyone take a look at this simple desired output. I am trying to create a formula but only using specific row and columns. THANK YOU 

[jrlindem · Accepted solution]

I'm sure there are other ways to do this, but i've broken this out to illustrate the steps you can take to get to where you need to be:

the workflow is also attached so you can dig in and adapt.  Hope this helps, -Jay

[HOUEW]

Thank you! The "transpose" idea really helped me cut down the steps! This worked!

[jrlindem]

@HOUEW  Awesome, glad I could help.  Go ahead and mark the response as the solution for other's benefit too!  Cheers and happy Alteryx'ing!  -Jay