{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Fill Handle Feature","Fill Down Feature","VLOOKUP function","Sheet1"," VBA","Item","Repeat","Merging Functions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Item","Grade","Stock"]
[null,"Laptop ","Grade 1",35]
[null,"Hard Disk ","Grade 2",50]
[null,"Motherboard","Grade 1",20]
[null,"UPS ","Grade 1",25]
[null,"Keyboard ","Grade 2",10]
[null,"RAM ","Grade 2",15]

{"sheet":"Fill Handle Feature","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Applying Fill Handle Feature ",null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Item","Grade","Stock",null,null,"Item","Grade","Stock"]
[null,"Laptop ","Grade 1",35,null,null,"Laptop ","Grade 1",35]
[null,"Hard Disk ","Grade 2",50,null,null,"Hard Disk ","Grade 2",50]
[null,"Motherboard","Grade 1",20,null,null,"Motherboard","Grade 1",20]
[null,"UPS ","Grade 1",25,null,null,"UPS ","Grade 1",25]
[null,"Keyboard ","Grade 2",10,null,null,"Keyboard ","Grade 2",10]
[null,"RAM ","Grade 2",15,null,null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]

{"sheet":"Fill Down Feature","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Employing Fill Feature from Ribbon",null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Item","Grade","Stock",null,null,null,"Item","Grade","Stock"]
[null,"Laptop ","Grade 1",35,null,null,null,"Laptop ","Grade 1",35]
[null,"Hard Disk ","Grade 2",50,null,null,null,"Hard Disk ","Grade 2",50]
[null,"Motherboard","Grade 1",20,null,null,null,"Motherboard","Grade 1",20]
[null,"UPS ","Grade 1",25,null,null,null,"UPS ","Grade 1",25]
[null,"Keyboard ","Grade 2",10,null,null,null,"Keyboard ","Grade 2",10]
[null,"RAM ","Grade 2",15,null,null,null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]
[null,"RAM ","Grade 2",15]

{"sheet":"VLOOKUP function","index":3,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Using VLOOKUP Function",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Helper Column","Item","Repeat Time ","Column2","Repeat",null,null,"Helper Column","Item","Repeat Time ","Column2","Repeat"]
[null,1,"Laptop ",2,1,{"$f":"VLOOKUP(E5,$B$4:$C$10,2)","v":"Laptop "},null,null,null,"Laptop ",2,1]
[null,{"$f":"B5+D5","v":3},"Hard Disk ",3,2,"Laptop ",null,null,null,"Hard Disk ",3,2]
[null,{"$f":"B6+D6","v":6},"Motherboard",3,3,"Hard Disk ",null,null,null,"Motherboard",3,3]
[null,{"$f":"B7+D7","v":9},"UPS ",2,4,"Hard Disk ",null,null,null,"UPS ",2,4]
[null,{"$f":"B8+D8","v":11},"Keyboard ",2,5,"Hard Disk ",null,null,null,"Keyboard ",2,5]
[null,{"$f":"B9+D9","v":13},"RAM ",3,6,"Motherboard",null,null,null,"RAM ",3,6]
[null,null,null,null,7,"Motherboard"]
[null,null,null,null,8,"Motherboard"]
[null,null,null,null,9,"UPS "]
[null,null,null,null,10,"UPS "]
[null,null,null,null,11,"Keyboard "]
[null,null,null,null,12,"Keyboard "]
[null,null,null,null,13,"RAM "]
[null,null,null,null,14,"RAM "]
[null,null,null,null,15,"RAM "]

{"sheet":"Sheet1","index":4,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,10]]}
[]
[null,"Using VLOOKUP Function",null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Helper Column","Item","Repeat Time ",null,null,"Helper Column","Item","Repeat Time ","Column2","Repeat"]
[null,1,"Laptop ",2,null,null,null,"Laptop ",2,1]
[null,null,"Hard Disk ",3,null,null,null,"Hard Disk ",3,2]
[null,null,"Motherboard",3,null,null,null,"Motherboard",3,3]
[null,null,"UPS ",2,null,null,null,"UPS ",2,4]
[null,null,"Keyboard ",2,null,null,null,"Keyboard ",2,5]
[null,null,"RAM ",3,null,null,null,"RAM ",3,6]

{"sheet":" VBA","index":5,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Inserting VBA Code",null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Item","Repeat Time ",null,"Product",null,null,null,null,null,null,"Item","Repeat Time ",null,"Product"]
[null,"Laptop ",2,null,"Laptop ",null,null,null,null,null,null,"Laptop ",2]
[null,"Hard Disk ",3,null,"Laptop ",null,null,null,null,null,null,"Hard Disk ",3]
[null,"Motherboard",3,null,"Hard Disk ",null,null,null,null,null,null,"Motherboard",3]
[null,"UPS ",2,null,"Hard Disk ",null,null,null,null,null,null,"UPS ",2]
[null,"Keyboard ",3,null,"Hard Disk ",null,null,null,null,null,null,"Keyboard ",3]
[null,"RAM ",3,null,"Motherboard",null,null,null,null,null,null,"RAM ",3]
[null,null,null,null,"Motherboard"]
[null,null,null,null,"Motherboard"]
[null,null,null,null,"UPS "]
[null,null,null,null,"UPS "]
[null,null,null,null,"Keyboard "]
[null,null,null,null,"Keyboard "]
[null,null,null,null,"Keyboard "]
[null,null,null,null,"RAM "]
[null,null,null,null,"RAM "]
[null,null,null,null,"RAM "]

{"sheet":"Item","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Items"]
[]
[null,"Item","Grade","Stock"]
[null,"Laptop ","Grade 1",35]
[null,"Hard Disk ","Grade 2",50]
[null,"Motherboard","Grade 1",20]
[null,"UPS ","Grade 1",25]
[null,"Keyboard ","Grade 2",10]
[null,"RAM ","Grade 2",15]

{"sheet":"Repeat","index":7,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combination of Functions"]
[]
[null,"Item","Grade","Stock"]
[null,"Laptop ","Grade 1",35]
[null,"Hard Disk ","Grade 2",50]
[null,"Motherboard","Grade 1",20]
[null,"UPS ","Grade 1",25]
[null,"Keyboard ","Grade 2",10]
[null,"RAM ","Grade 2",15]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(B5))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:B5)-(COUNTA(Item!B:B)-2))),Item!B5)","v":"Laptop "},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(C5))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:C5)-(COUNTA(Item!C:C)-2))),Item!C5)","v":"Grade 1"},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(D5))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:D5)-(COUNTA(Item!D:D)-2))),Item!D5)","v":35}]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(B6))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:B6)-(COUNTA(Item!B:B)-2))),Item!B6)","v":"Hard Disk "},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(C6))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:C6)-(COUNTA(Item!C:C)-2))),Item!C6)","v":"Grade 2"},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(D6))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:D6)-(COUNTA(Item!D:D)-2))),Item!D6)","v":50}]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(B7))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:B7)-(COUNTA(Item!B:B)-2))),Item!B7)","v":"Motherboard"},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(C7))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:C7)-(COUNTA(Item!C:C)-2))),Item!C7)","v":"Grade 1"},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(D7))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:D7)-(COUNTA(Item!D:D)-2))),Item!D7)","v":20}]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(B8))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:B8)-(COUNTA(Item!B:B)-2))),Item!B8)","v":"UPS "},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(C8))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:C8)-(COUNTA(Item!C:C)-2))),Item!C8)","v":"Grade 1"},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(D8))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:D8)-(COUNTA(Item!D:D)-2))),Item!D8)","v":25}]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(B9))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:B9)-(COUNTA(Item!B:B)-2))),Item!B9)","v":"Keyboard "},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(C9))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:C9)-(COUNTA(Item!C:C)-2))),Item!C9)","v":"Grade 2"},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(D9))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:D9)-(COUNTA(Item!D:D)-2))),Item!D9)","v":10}]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(B10))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:B10)-(COUNTA(Item!B:B)-2))),Item!B10)","v":"RAM "},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(C10))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:C10)-(COUNTA(Item!C:C)-2))),Item!C10)","v":"Grade 2"},{"$f":"IF(ISBLANK(INDIRECT(\"Item!B\"&ROW(D10))),INDIRECT(\"Repeat!B\"&(ROWS($B$5:D10)-(COUNTA(Item!D:D)-2))),Item!D10)","v":15}]

{"sheet":"Merging Functions","index":8,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merging Functions"]
[null,null,null,null,null,"Helper 1"]
[null,"Item","Repeat Time","Repeated Items",null,{"$f":"TRIM(_xlfn.TEXTJOIN(\" \",TRUE,REPT(ROW(B5:B100)&\" \",C5:C100)))","v":"5 5 6 6 7 7 7 8"}]
[null,"Laptop ",2,{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($F$7),ROW(B5:$B$100),B5:B100)","v":"Laptop "}]
[null,"Hard Disk ",2,"Laptop ",null,"Helper 2"]
[null,"Motherboard",3,"Hard Disk ",null,{"$f":"IFERROR(_xlfn.FILTERXML( \"<a><b>\"&SUBSTITUTE(F4,\" \",\"</b><b>\")&\"</b></a>\", \"//b\"),\"\")","v":5}]
[null,"UPS ",1,"Hard Disk ",null,5]
[null,null,null,"Motherboard",null,6]
[null,null,null,"Motherboard",null,6]
[null,null,null,"Motherboard",null,7]
[null,null,null,"UPS ",null,7]
[null,null,null,null,null,7]
[null,null,null,null,null,8]