How to copy a cell every 2 rows?

Hi :grinning:,

I would like to cut the records different than “CA” from column L and paste them into the empty cells of column F. How can I achieve that?

From this:

To this:

I was thinking that maybe using Read Range and For Each activities, but I’m not pretty sure what other activity can I use…maybe and if statement …?

Thanks in advance!

@Tana20 - In the for each loop of datatable

If row("L"COlumnName).tostring.contains(“CA”)
Then → Do nothing
Else → row("F"ColumName) = row("L"COlumnName).tostring

        This will assign X to Column F. 
        After the you can add another assign row("L"COlumnName) = String.empty

Finally use write range to write the output.

Please try this out…

1 Like

@Tana20 - I just tested it…it working fine…



1 Like

Thank you! it works as expected :partying_face:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.