I have a Column with with content like, AA,BB,CC,DD and in column B I have multiple dates for the same entry in Column A i.e, AA value in column A have 3 dates in column B.
Now the requirement is values in column A should get only the least date from Coulmn B.
Can someone help me out on this
Input | |
Column A | Column B |
AA | 2001-12-23 |
AA | 2020-01-23 |
AA | 2025-03-21 |
BB | 2025-01-03 |
CC | 2024-10-16 |
CC | 2023-09-28 |
CC | 2022-06-30 |
CC | 2019-11-01 |
Output | |
Column A | Column B |
AA | 2001-12-23 |
BB | 2025-01-03 |
CC | 2019-11-01 |
Hi @flying008
Thanks for sharing. Can you please share me the workflow which might be useful