Hello there,
So, Table 1 is an example of how my actual data looks like. I am trying to get to table 2.
So basically, if I have a line then I should bring the line due date. If I don't have a line but have a CC, then I should have the CC due date instead.
The order would be Line > CC > Loan > Mod.
I think the multi-row would be the best tool but unsure how to write the formula.
Table 1:
Loan ID | Product | Due Date |
1122 | Loan | 3/1/2024 |
1122 | CC | 4/2/2024 |
1122 | Line | 3/13/2024 |
1400 | Mod | 5/2/2024 |
1400 | Loan | 6/2/2024 |
1400 | CC | 8/3/2024 |
1900 | Term | 3/4/2024 |
1900 | Mod | 4/5/2024 |
Table 2:
Loan ID | Product | Due Date |
1122 | Line | 3/13/2024 |
1400 | CC | 8/3/2024 |
1900 | Term | 3/4/2024 |
Solved! Go to Solution.
@Kristie_Pires
We can prepare a mapping list for your products and their order in simple alphabet.
Then we can do sorting and Sample one item from each Load ID, that would be pretty easy.
@Kristie_Pires another approach
Thank you all for providing multiple solutions to my problem! Truly appreciate you 😁
Glad to help. 😁