Need Formula for C and D Column

If B column is morethan 1 then it should be come like 1, 1a, 1b, 1c, 1d, 1e etc… and next column is separate alone number means then it should be 2, 3, 4, 5, 6….

Try this in C2

Please Login or Register  to view this content.

D2

Please Login or Register  to view this content.

Both copied down.

Hatts off sir, Its working fine and great sir. Thank you so much sir

You are welcome.