How to Transform Cross-Tab Data to List Format in Alteryx

[KamenRider]

Hi

Could someone guide me on the best approach to achieve this transformation in Alteryx? Any tips on using specific tools or configurations would be greatly appreciated. Note also that there are a lot more reject reasons that will be added and hoping that the total will also adjust.

I have attached the input file for your reference. Below is also the screenshot.

 

This is the output I would like to generate. 

Please help.

Thanks,

Kamen

 

[binuacs · Accepted solution]

@KamenRiderIf it still isn't working, please provide some sample data that is similar to the actual records you are facing the issue with. Also is the provided workflow working for you before connecting your actual data?

[KamenRider]

Hi @binuacs

Here's the sample workflow (unfinished) and the input files for your reference.

Looking forward  for your response.

Kamen

[binuacs · Accepted solution]

@KamenRider updated the workflow

[KamenRider]

Thank you so much @binuacs . You nailed it!

Kamen