Hello,
Please help me to join the below data
INPUT | |||
Sedol | Record date2 | Record date3 | Record date4 |
7108899 | 2022-03-29 | 2022-03-29 | 2022-03-29 |
4031976 | 2022-05-16 | 2022-05-16 | |
B1L95G3 | 2022-11-01 | 2022-11-01 | |
0287580 | 2022-12-23 | ||
BJMY6G0 | 2022-03-31 | ||
BJMY6G0 | 2022-03-31 | ||
BH6XZT5 | 2022-03-24 | ||
2793115 | 2022-03-24 | ||
2793115 | 2022-03-24 | ||
Output | |||
Sedol | Record date | ||
7108899 | 2022-03-29 | ||
4031976 | 2022-05-16 | ||
B1L95G3 | 2022-11-01 | ||
0287580 | 2022-12-23 | ||
BJMY6G0 | 2022-03-31 | ||
BJMY6G0 | 2022-03-31 | ||
BH6XZT5 | 2022-03-24 | ||
2793115 | 2022-03-24 | ||
2793115 | 2022-03-24 |
Just as a question:
If the priority of dates goes from left to right, wouldnt it be way more simple to put a formula tool in column "Record date 2" which says sth like:
IF [Record date 2] != Null()
THEN [Record date 2]
ELSEIF [Record date 3] != Null()
THEN [Record date 3]
ELSEIF [Record date 4] != Null()
THEN [Record date 4]
ELSE "No Date, lul"
ENDIF
Or do I miss an important point?
BR