Copy one column data and paste it another column if it is empty

[Abhoy_Kumar_Mondal]

I want to write a logic if G11 and I11 column is empty then we will copy H11 column data and paste into G and I column.

[Yoichi]

Hi,

How about the following?

Condition

String.IsNullOrEmpty(CurrentRow("General").ToString) AndAlso String.IsNullOrEmpty(CurrentRow("Private").ToString)

Then

CurrentRow("General") = CurrentRow("Semi-Private").ToString

CurrentRow("Private") = CurrentRow("Semi-Private").ToString

Sample
Sample20231123-1aL.zip (7.3 KB)

Regards,

[Abhoy_Kumar_Mondal]

First of all thanks for your help, but if you see 20 no-row, the above condition fails here. so can you please guide me on how to deal with it?

[Yoichi]

Hi,

If your requirement is independently “If column G is empty, copy from column H” AND “If column I is empty, copy from column H”, the following will work.

Sample
Sample20231123-1aLv2.zip (7.3 KB)

Regards,