We are working on an excel file which has more data and need to replace data with a specific column.
A - contains primary data--- let's say 1000005
B - Contains secondary data- Let's say, Customer name
C- Output required with customers full name or ignore blank in 'D"
D- Contains customers full name few are blank.
we used =D2 to replace the content of Column D to Column C, under the filter option...but it messed up the excel.
Tried sorting and use the same method...it messed up again
A - contains both Text and General as the numeric begins with "zero"
Suggest an option.