How to avoid double or third results after transpose and cross tab?

[maxtla]

Hi,

For a clean join, I used transpose and cross tab. But the results in many columns are double or three time written.

How to avoid this?

Thanks for your any help.

[JamesCharnley]

Hi @maxtla ,

I think the easiest thing to do here is to just add a unique tool before the transpose and 'Select all'

[Christina_H]

Try a unique tool between the transpose and crosstab tools to get rid of duplicate rows

The column order gets messed up but that's easy to fix.

[maxtla · Accepted solution]

Thanks very much for your response!

is working good!