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.
Solved! Go to Solution.
Hi @maxtla ,
I think the easiest thing to do here is to just add a unique tool before the transpose and 'Select all'
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.
Thanks very much for your response!
is working good!