AAP
Member
Hello SuperUsers, I have a situation where column 2 needs to be filled. Values will be taken by first from column 1 but if some rows are empty in column 1 then take values from column 3 and fill column 2. My normal files contains 700,000 rows. If I loop then it takes 10 minutes to complete operation. I am looking for an efficient way to do this operation. Please advice.