This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am using Cross Tab on the data set below where I group Column Type by Reference so for reference 29115742 the Output will be 2A2B because reference 29115742 has 2 rows. Reference 29120410 has 4 rows therefore the Output will be 2A2A2B2B. Can you please tell me whether is there a way to change the output for 29120410 to 2A2B so that it will only take the first identical value?
If your data is identical and you don't want to see it duplicated after the cross tab, use a Unique tool to remove the actual duplicates. In your case, select Reference and Type as the fields to check for unique values.