I recently was able to concatenate 3 columns in an output successfully but saw there were 7 duplicates. I then was able to concatenate 3 different columns to get rid of the duplicates. Now those 7 items (rows) have the concatenation in the new 3 but not in the previous 3 columns. Ever other row is fine except the 7 duplicates. See screenshot for more details. Image Alteryx_26 is the same for the next two transpose except it says column 3 and 4. If any one replying needs more information please let me know I'm completely lost.
Can you provide some sample data and the workflow so that the Community can assist. The screenshot show the tools but not the data so it's difficult to understand what you are attempting to do.
DanM
Thanks for replying, but I figured it out !
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |