Hi
I have below table
Month | Cur | Amnt |
FEB | EUR | 10 |
FEB | USD | 20 |
FEB | INR | 30 |
MAR | USD | |
MAR | INR | |
MAR | EUR | |
APR | INR | |
APR | USD | |
APR | EUR |
I want below expected output. It would be the same value as Feb value based on their respective currency.
Month | Cur | Amnt |
FEB | EUR | 10 |
FEB | USD | 20 |
FEB | INR | 30 |
MAR | USD | 20 |
MAR | INR | 30 |
MAR | EUR | 10 |
APR | INR | 30 |
APR | USD | 20 |
APR | EUR | 30 |
Thank you,
Solved! Go to Solution.
Yes 🙂 Thank you so much for your quick response.