Merge multiple Columns into one keeping uniques

[espinobj]

Good afternoon,

Very new and still learning Alteryx.

Here is the data I have. I have 4 columns pulling data from different places. I want to end up with the "Result" Essentially merge any uniques into one. And in the last row note it kept both values but still merged the unique values into one. There is a lot of other data after these fields. 

All 4 NODE ID's could be empty or could be 4 unique values. 

I tried some complicated If then statements and gave up. I couldn't get Summarize to work as mentioned HERE

This is also what I'm looking to do. This was a feature request. Concatenate Unique  

Running Alteryx Designer 2023.1.1.123

NODE ID	NODE ID 2	NODE ID 3	NODE ID 4	RESULT
123ABC	123ABC	123ABC	123ABC	123ABC
789CDE		789CDE		789CDE
			789CDE	789CDE
ABC123	ABC123	ABC123	ABC123	ABC123
HIK678	L9999L	HIK678	HIK678	HIK678 ; L9999L

[nagakavyasri · Accepted solution]

[FrederikE · Accepted solution]

Hey @espinobj,

This is how I'd do it. 

Spoiler

[espinobj]

This worked great. I'm trying to understand your choice. What is the need of "trim" in the multi field formula?

[espinobj]

Your solution is exceptionally simple and more in my skills to be able to manipulate. Both worked great thank you!

[nagakavyasri]

To remove whitespaces if you have any.