Multilevel data in different columns

[MadiNissi]

Hello,

I have a file with eight columns (A to H), each one representing the description of the code in column I. Is there a way to have one column with the respective material description?

I am not sure if I was clear but below you can see an example:

- Code 45 has the description in column A

- Code 45,200 to 4511 has the description in column B

- Code 451116 has the description in column C

I am looking for a solution in Alteryx to have two columns: one for the material code and another for the description.

Did anybody work on this before? Would you mind sharing your thoughts?

Thank you.

Madi

[CarliE]

@MadiNissi 

Can you send a sample dummy data excel file? and the expected outcome?

[MadiNissi]

@CarliE - Sure, please find attached the dummy data.

[CarliE]

@MadiNissi

Is this what you are looking for?

Attached is the workflow. I transposed the data, filtered nulls out and ended up like this.

If this solved your problem, please make sure to mark it as a solution!

Thanks

[acarter881 · Accepted solution]

Hello @MadiNissi. Here's how to get the exact output you are looking for.

[binuacs · Accepted solution]

@MadiNissi Similar to other solutions

[MadiNissi]

Hi - It worked! Thank you for sharing the solution! 😉