question on how to stack multiple columns into one

[chirimoyayachay]

Hi,

I have a question of how to quickly stack multiple columns into one

I have a daily task in Alteryx involving a complex dataset. The dataset contains medical diagnoses and diagnostic codes, but it is organized by patient.

I want to transform this data into a simpler format with only two columns:

1. Diagnostic Code
2. Diagnosis

Can you help me with this transformation in Alteryx?

this is my work flow, and also dataset. I split data into two tables, but still I felt it is too redundant, could anyone show me a easier way to do so?

thanks!

[Raj · Accepted solution]

@chirimoyayachay 
simple way to this
and this will work for n number of columns dynamically

mark done if solved.

[Qiu]

@chirimoyayachay 
A slightly different approach with @Raj .
Anyway, we need to make this dynamic, so the combination of Transpose and Cross Tab is good for multiple-columns issues.

[chirimoyayachay]

thank you for your reply, I like this multiple row formula, simple and easy to follow!

[chirimoyayachay]

thank you for your reply,

!