How to add value in excel row sequentially

[rsr.chandu]

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

[Anil_G (Anil Gorthi)]

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

[RajKumar_DC (RajKumar Durai)]

Hi @rsr.chandu,

What about this workflow

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

Input

Output

Workflow

Thanks,
Rajkumar

[rsr.chandu]

Can you share this xaml workflow

[RajKumar_DC (RajKumar Durai)]

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