<pre>
I have table as below, in row number 2("AAPOP"), 6("AB"), 9("QDA98"), I don't have any value in "remarks" and "details" column
Particulars Remark Details AMT
AAPOP
QP av daf 7
WP ad dae 8
ST df dds 9
AB
RR dasd df 6
RA dsf we 8
QDA98
DRS sd df 5
DRW sd dsa 3
UTS dad fds 6
I want to create "log" column and paste value for those column who is not contain any value in column 'remarks' and 'details', in below example it is "AAPOP, "AB", "QDA98"
Particulars Remark Details log AMT
AAPOP AAPOP
QP av daf 7
WP ad dae 8
ST df dds 9
AB AB
RR dasd df 6
RA dsf we 8
QDA98 QDA98
DRS sd df 5
DRW sd dsa 3
UTS dad fds 6
</pre>