Show Bonus

[BRRLL99]

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

[Felipe_Ribeir0]

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.

[BRRLL99]

As shown in the Expected output

even 1:1 etc; should be removed from the column Data

[Felipe_Ribeir0 · Accepted solution]

Hi @BRRLL99

Try this one.