Stacking multiple rows into columns (Next to each other) + Removing any NULLS

[ljohn]

Hi,

I am trying to transform my data - examples below. Use of Summarize, transform & formula isnt helping.

The output should show only real values, any zeros should be removed

Thanks!

[JosephSerpis · Accepted solution]

Hi @ljohn I mocked up a workflow however Alteryx does not allow you have columns with the same name so will always make them unique so had to number the cases column.

[ljohn]

Appreciate it! It worked perfectly