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.
