How to copy data that only has data to other cells

[wsinten (KANZ)]

Hi,

I need help. I want to copy the values ​​in column C to column A without changing all the contents of the data in column A (example only the contents of C3 to A3, C10 to A10 and C14 to A14). anyone can help? Thank You

[Suraj_B_Shetty (Suraj)]

Hi @wsinten

For Each row As datarow In in_DT.Rows
If Not String.IsNullOrEmpty(row(“C”).ToString) Then
row(“A”) = row(“C”).ToString
End If
Next

Try this code. Hope this helps

[fernando_zuluaga]

Hi @wsinten

what about the following?

Regards

[Suraj_B_Shetty (Suraj)]

Check this workflow.
Filter.xaml (8.4 KB)

[wsinten (KANZ)]

Hi @fernando_zuluaga thank you for your answer. But still not working.

[wsinten (KANZ)]

Hi @Suraj_B_Shetty,

thank you for wanting to answer me. but your file can’t be opened on me. can you just take a screenshot for me? thank you

[fernando_zuluaga]

Hi @wsinten

i made a mistake check this now

Not(String.IsNullOrEmpty(CurrentRow(2).ToString())) OrElse Not(String.IsNullOrWhiteSpace(CurrentRow(2).ToString()))

you can also change the index number of the columns for your columns names

Regards

[Suraj_B_Shetty (Suraj)]

Use this inside invoke code

Pass Arguments