Crosstab or Transpose.

[sghimire]

Can someone point me in the right direction to get the desired output from the sample file attached.

[ConnorK · Accepted solution]

Hi @sghimire ,

To get the data in that exact format you will want to combine data based on type and date, and then provide unique identifiers for the different dates. Once, this is done you will need to perform two cross-tabs and you will get the final table by joining the two cross-tab results together.

Please see the attached workflow.

I hope this helps!

[fmvizcaino · Accepted solution]

Hi @sghimire ,

Not sure if it is the best solution, but it does the job!

I'm attaching an example showing how to get that done. The only detail is, since Alteryx can't handle columns with the same name, I've inserted a number after each column to order them properly.

Best,

Fernando Vizcaino

[sghimire]

Perfect. Thanks for the help.