Hi,
I have a access table which contains few rows.
I need to compare each row in the table with other rows in the same sheet.
Key Unit Assembly Effective_Date
10 05100070 6666666H92 05/02/2012
10 05100070 10/02/2012
20 05100070 6666666H93 15/01/2013
30 05100070 9999999H92 20/02/2012
30 05100070 25/02/2012
40 05100070 9999999H93 30/01/2013
50 05100070 7777777H92 05/02/2012
50 05100070 10/02/2012
60 05100070 7777777H93 15/01/2013
70 05100070 5555555H92 20/02/2012
70 05100070 25/02/2012
80 05100070 5555555H93 30/01/2013
Logic:
If column "Key" contains different data in 2 rows then check column "Unit", If column "Unit" contains same data then check "Assembly",
If column "Assembly" in one row is empty and column "Assembly" in another row has data then copy the value of column "Effective_Date" (column "Assembly" has value) to column "Effective_Date" of the row which is empty in column "Assembly".
required output:
Key Unit Assembly Effective_Date
10 05100070 6666666H92 05/02/2012
10 05100070 15/01/2013
20 05100070 6666666H93 15/01/2013
30 05100070 9999999H92 20/02/2012
30 05100070 30/01/2013
40 05100070 9999999H93 30/01/2013
50 05100070 7777777H92 05/02/2012
50 05100070 15/01/2013
60 05100070 7777777H93 15/01/2013
70 05100070 5555555H92 20/02/2012
70 05100070 30/01/2013
80 05100070 5555555H93 30/01/2013
Thanks in advance.
Bookmarks