Combining Multiple Columns

[RBoyd]

I have 2 sets of columns, each with name and email address, as part of a larger dataset.  I need to combine the 2 sets of columns into one and duplicate and insert the entire row if the differ.

Example:

This is part of a larger data set but these are the relevant sets of columns. 

If both sets are the same, nothing needs to be done. 

If name and email 1 is empty then name and email 2 should be moved to name and email 1

If the data differs, i need the entire row duplicated with the name 2 and email 2 replacing name 1 and email 1 in the newly generated row.

Example of what the data should look like after:

If I can provide any additional information, please let me know. Thanks!

[binuacs]

@RBoyd One way of doing this

[RBoyd]

@binuacs This way did not duplicate the final row and bring in the final name (sally) in Name 2 email 2

[binuacs]

@RBoyd I updated the workflow, let me know if that works for you

[flying008]

Hi, @binuacs 

Nice job ! 👍