Aligning Texts in two different Columns when they 'Match'

Question

Hello,

I have a set of data with customer names that were changed few times over a period of time and in the Columns "Old name" and "New name". I have all the Old Names and the New names but only the latest name change date. I tried to do different types of sorting, but could not line up the names that are the same for both Old and New name. I am not sure why.

Can someone help me build a solution where the Old name and the New names that are the same will align (next to each other) and the names do not match can go anywhere.

I am attaching the sample data set. In this data the names highlighted in blue and green in "Old name" and "New name" columns are the exact same names and should be in the same line next to each other.

Thank you

Sample_data.xlsx

Rumanais · Answer

Hello Yoshiro_Fujimori,

Thank you for putting detail thought into the problem.  It is actually more simpler then that. The expected action should have been achieved through excel, but I cannot tell why the excel is not producing the result.

However, I am attaching the problem and the expected outcome in the excel file again.

Hope this helps.

Sample_data.xlsx

Yoshiro_Fujimori · Answer

@Rumanais ,

I interpret your requirement is to get the below data for each customer each day;

1. the names at the beginning and the end of the day

2. the names changed during the day

So I designed a workflow to put all the names together, and check the count of the names to differentiate above 1. and 2.

Input

Workflow

Output-1 (Names changed during the day)

Output-2 (Names at the beginning and the end of the day)

Does it work for your case?

MatchColumns.yxmd

Rumanais · Answer

Thank you gaoa! This would work, but since my data set is large, is there a way to remove the rows with the null values? I am thinking may be adding two new columns after the sort, 'New Old Name' and 'New New Name'....