Hi Team,
I have Following Data-set
Data |
Final Dividend - Rs. - 45.0000 |
Bonus issue 1:1 |
Stock Split From Rs.10/- to Rs.2/- |
Bonus issue 8:1 |
Bonus issue 1:2 |
Bonus issue 3:2 |
Interim Dividend |
Dividend - Rs. - 0.5000 |
Expected Output
Data | |
Final Dividend - Rs. - 45.0000 | |
Bonus issue | 1:1 |
Stock Split From Rs.10/- to Rs.2/- | |
Bonus issue | 8:1 |
Bonus issue | 1:2 |
Bonus issue | 3:2 |
Interim Dividend | |
Dividend - Rs. - 0.5000 |
Solved! Go to Solution.
Hi @BRRLL99
One way of doing this, the workflow is attached.
If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)
Thanks.
As shown in the Expected output
even 1:1 etc; should be removed from the column Data