Poblem transposing data

[Swethaj1994]

Hi All,

I'm pretty new to Alteryx!

I used transpose tool to convert 2 columns in one field and merge for e.g. category and date in order to eliminate duplicates. but it doesn't work as I expected.

Attached data file

Thanks,
Swetha J

[Thableaus · Accepted solution]

Hi @Swethaj1994!

You should use the Cross Tab Tool in this situation. And group by Category and Date.

See attached workflow.

Cheers,