one of my row output contains some output values and some erros.I want to
consolidate that row values without error values.I used iserror function but
results are more are less same output values and blank value and output
vales.To get in another row only output values whats the formula.suppose
b1:b6 range contains
data1,error,data2,error,error,data3,Iwant in another row serially in c1:c3
data1,data2,data3.