Create an attribute containing the 3 merged values as comma separated values (you'll need a conditional formula to handle that they're not always populated), an attribute splitter to split on the comma then a list exploder.

You could also use the renaming approach you mentioned, but after renaming you will need to test that the attribute has a value since you have blanks in your merged columns e.g.

you can list_concatenate the 3 columns by row_id.

Then explode list.

FeatureMerge with the other columns on key= row_id. Process duplicates and explode.

Sort.

I would use a stringconcatenator to concatenate the three strings that need to be merged. Then use a AttributeSplitter with Drop Empty Parts = Yes to create a list called Merged. The last step is to Explode this list with the ListExploder.

So far this has come the closest to solving it but it's still off by a few features. It probably needs some more tweaking on my end. Thanks.

If your input is originally coming from excel the first thing I'd check is whether some of the merge columns have spaces in rather than being blank

It's coming from a GDB file and I also don't think spaces are being used because all the unused rows are showing up as 'Null' rather than being blank.

Off topic, how do I go about reporting small things such as typos? Because I know that for ideas or feature requests there is a section but something as small as a typo probably wouldn't warrent its own topic.

Hi @bkgg. I'm not the expert, so can't be much help with this particular workflow.

Thanks. I just finished filling in the form.