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
