Split and add data row


#1

Hi
I have a column with string, integer and blank rows. I want to split the string and add data row below it.
Here is the sample file Book1.xlsx (11.7 KB)

example:
input: 2345
100 promo,104 promo,108 promo
output : 2345
100promo
104 promo
108 promo


#2

Hi @Atul_Rai ,

Use below code
Arrvalue=Yourstring.Replace(Environment.NewLine,",").split(","c)


#3

Thanks @akila93 for your reply.
It is not working. Can you provide a sample .xaml file with reference to my attached .xlsx file.