How to add value in excel row sequentially

PFA

From the above attached excel sheet i need the values pasted like “Expected Status”
but my bot is pasting the value from web application into excel like this

PFA



i used index counter, followed by repeat number of times activity under this i was placed write cell

How to fix this error?

Thanks in advance

Hi @rsr.chandu

Dis you place the index+1 assign inside number of times loop?

If so move it to out to the for each ro
Cheers

Hi @rsr.chandu,

What about this workflow

convert Column value to List with filtered empty value then add to rows.

Input
image

Output
image

Workflow

Thanks,
Rajkumar

Can you share this xaml workflow

Hi @rsr.chandu ,

Kindly check this

Xaml
15.xaml (11.3 KB)

list_ShipmentID

(From row In in_dt.AsEnumerable() Select Convert.ToString(row("ShipmentID").ToString)).ToArray.where(Function(x) Not String.IsNullOrWhiteSpace(x)).tolist

list_Status

(From row In in_dt.AsEnumerable() Select Convert.ToString(row("Status").ToString)).ToArray.where(Function(x) Not String.IsNullOrWhiteSpace(x)).tolist