{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["IF function","IF+ISBLANK function","IF+LEN & TRIM","Nested IF","VBA Macros"],"read":"whole","date_system":"1900"}

{"sheet":"IF function","index":0,"n_rows":11,"n_cols":4,"rows_kept":11}
["ID","Primary Value","Backup Value","Final Output "]
[1,null,"Apple",{"$f":"IF(B2=\"\",C2,B2)","v":"Apple"}]
[2,"Banana","Mango",{"$f":"IF(B3=\"\",C3,B3)","v":"Banana"}]
[3,null,"Orange","Orange"]
[4,"Grape","Pear","Grape"]
[5,null,"Kiwi","Kiwi"]
[6,"Mango","Papaya","Mango"]
[7,null,"Cherry","Cherry"]
[8,"Pineapple",null,"Pineapple"]
[9,null,"Watermelon","Watermelon"]
[10,"Guava",null,"Guava"]

{"sheet":"IF+ISBLANK function","index":1,"n_rows":11,"n_cols":4,"rows_kept":11}
["ID","Primary Value","Backup Value","Final Output "]
[1,null,"Apple",{"$f":"IF(ISBLANK(B2),C2,B2)","v":"Apple"}]
[2,"Banana","Mango",{"$f":"IF(ISBLANK(B3),C3,B3)","v":"Banana"}]
[3,null,"Orange","Orange"]
[4,"Grape","Pear","Grape"]
[5,null,"Kiwi","Kiwi"]
[6,"Mango","Papaya","Mango"]
[7,null,"Cherry","Cherry"]
[8,"Pineapple",null,"Pineapple"]
[9,null,"Watermelon","Watermelon"]
[10,"Guava",null,"Guava"]

{"sheet":"IF+LEN & TRIM","index":2,"n_rows":11,"n_cols":4,"rows_kept":11}
["ID","Primary Value","Backup Value","Final Output "]
[1,"      ","Apple",{"$f":"IF(LEN(TRIM(B2))=0, C2, B2)","v":"Apple"}]
[2,"Banana","Mango",{"$f":"IF(LEN(TRIM(B3))=0, C3, B3)","v":"Banana"}]
[3,null,"Orange","Orange"]
[4,"Grape","Pear","Grape"]
[5,null,"Kiwi","Kiwi"]
[6,"Mango","Papaya","Mango"]
[7,null,"Cherry","Cherry"]
[8,"Pineapple",null,"Pineapple"]
[9,null,"Watermelon","Watermelon"]
[10,"Guava",null,"Guava"]

{"sheet":"Nested IF","index":3,"n_rows":11,"n_cols":7,"rows_kept":11}
["ID","Primary","Backup 1","Backup 2","Backup 3","Backup 4","Final Output "]
["R001",null,"Apple",null,"Banana",null,{"$f":"IF(B2<>\"\",B2,IF(C2<>\"\",C2,IF(D2<>\"\",D2,IF(E2<>\"\",E2,F2))))","v":"Apple"}]
["R002","Orange",{"$nulls":4},{"$f":"IF(B3<>\"\",B3,IF(C3<>\"\",C3,IF(D3<>\"\",D3,IF(E3<>\"\",E3,F3))))","v":"Orange"}]
["R003",null,null,"Mango",null,null,"Mango"]
["R004",{"$nulls":3},"Peach",null,"Peach"]
["R005",{"$nulls":4},"Kiwi","Kiwi"]
["R006","Grapes",{"$nulls":4},"Grapes"]
["R007",null,"Cherry",{"$nulls":3},"Cherry"]
["R008",{"$nulls":3},"Papaya",null,"Papaya"]
["R009",{"$nulls":4},"Lychee","Lychee"]
["R010","Pine",{"$nulls":4},"Pine"]

{"sheet":"VBA Macros","index":4,"n_rows":11,"n_cols":7,"rows_kept":11}
["ID","Primary","Backup 1","Backup 2","Backup 3","Backup 4","Final Output "]
["R001",null,"Apple",null,"Banana",null,"Apple"]
["R002","Orange",{"$nulls":4},"Orange"]
["R003",null,null,"Mango",null,null,"Mango"]
["R004",{"$nulls":3},"Peach",null,"Peach"]
["R005",{"$nulls":4},"Kiwi","Kiwi"]
["R006","Grapes",{"$nulls":4},"Grapes"]
["R007",null,"Cherry",{"$nulls":3},"Cherry"]
["R008",{"$nulls":3},"Papaya",null,"Papaya"]
["R009",{"$nulls":4},"Lychee","Lychee"]
["R010","Pine",{"$nulls":4},"Pine"]