How to add cells in front of each "text" in excel?

[Ben_siu]

Hi,

I want to if there is a way to add 1 blank cells in front of each cells with the same specific strings , e.g. i want to insert a blank cell before “b”

which should become this:

[Gokul001 (Gokul Balaji)]

HI @Ben_siu

Have you tried with Write cell activity

Regards
Gokul

[supermanPunch (Arpan)]

Hi @Ben_siu ,

Could you Check the below workflow :
Excel_AddCell_BeforeSpecificValue.zip (9.0 KB)

The usage of SkipWhile() and TakeWhile() methods helps us in achieving the result as required. However, there are still open questions that we would ask, but you could try out the workflow provided and let us know if your requirement is complete or if you are facing any issues with different data samples that you use.