{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Approach 1","Approach 2","VBA","Table1","Table List","Multiple selections"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Creating List from Range"]
[]
[null,"Brand","Famous for"]
[null,"Pizza Hut","Pizza"]
[null,"KFC","Chicken Fry"]
[null,"McDonald's","Burger"]
[null,"Pepsi","Soft Drink"]
[null,"Maggi","Noodles"]
[null,"Subway","Sandwich"]
[null,"Starbucks","Coffee"]
[null,"Buffalo Wild Wings","Steak"]

{"sheet":"Approach 1","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Creating List from Range"]
[]
[null,"Brand","Famous for",null,"Brand","Famous for"]
[null,"Pizza Hut","Pizza"]
[null,"KFC","Chicken Fry"]
[null,"McDonald's","Burger"]
[null,"Pepsi","Soft Drink"]
[null,"Maggi","Noodles"]
[null,"Subway","Sandwich"]
[null,"Starbucks","Coffee"]
[null,"Buffalo Wild Wings","Steak"]

{"sheet":"Approach 2","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Creating List from Range"]
[]
[null,"Brand & Famous for",null,"Unique List"]
[null,"Pizza Hut",null,{"$f":"INDEX(B6:B21,MATCH(0,COUNTIF($D$5:D5,B6:B21),0))","v":"Pizza Hut"}]
[null,"KFC",null,{"$f":"INDEX(B7:B22,MATCH(0,COUNTIF($D$5:D6,B7:B22),0))","v":"KFC"}]
[null,"Pizza Hut",null,{"$f":"INDEX(B8:B23,MATCH(0,COUNTIF($D$5:D7,B8:B23),0))","v":"Pepsi"}]
[null,"Pepsi",null,{"$f":"INDEX(B9:B24,MATCH(0,COUNTIF($D$5:D8,B9:B24),0))","v":"Maggi"}]
[null,"Maggi",null,{"$f":"INDEX(B10:B25,MATCH(0,COUNTIF($D$5:D9,B10:B25),0))","v":"Starbucks"}]
[null,"Starbucks",null,{"$f":"INDEX(B11:B26,MATCH(0,COUNTIF($D$5:D10,B11:B26),0))","v":"Buffalo Wild Wings"}]
[null,"Starbucks",null,{"$f":"INDEX(B12:B27,MATCH(0,COUNTIF($D$5:D11,B12:B27),0))","v":"Burger"}]
[null,"Buffalo Wild Wings",null,{"$f":"INDEX(B13:B28,MATCH(0,COUNTIF($D$5:D12,B13:B28),0))","v":"Sandwich"}]
[null,"Maggi",null,{"$f":"INDEX(B14:B29,MATCH(0,COUNTIF($D$5:D13,B14:B29),0))","v":"Steak"}]
[null,"Maggi"]
[null,"Burger"]
[null,"Starbucks"]
[null,"Pepsi"]
[null,"Sandwich"]
[null,"Sandwich"]
[null,"Steak"]

{"sheet":"VBA","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Creating List from Range"]
[]
[null,"Brand","Famous for",null,"Brand & Famous for"]
[null,"Pizza Hut","Pizza",null,"Pizza Hut"]
[null,"KFC","Chicken Fry",null,"Pizza"]
[null,"McDonald's","Burger",null,"KFC"]
[null,"Pepsi","Soft Drink",null,"Chicken Fry"]
[null,"Maggi","Noodles",null,"McDonald's"]
[null,"Subway","Sandwich",null,"Burger"]
[null,"Starbucks","Coffee",null,"Pepsi"]
[null,"Buffalo Wild Wings","Steak",null,"Soft Drink"]
[null,null,null,null,"Maggi"]
[null,null,null,null,"Noodles"]
[null,null,null,null,"Subway"]
[null,null,null,null,"Sandwich"]
[null,null,null,null,"Starbucks"]
[null,null,null,null,"Coffee"]
[null,null,null,null,"Buffalo Wild Wings"]
[null,null,null,null,"Steak"]

{"sheet":"Table1","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Brand","Attribute","Value"]
["Pizza Hut","Famous for","Pizza"]
["KFC","Famous for","Chicken Fry"]
["McDonald's","Famous for","Burger"]
["Pepsi","Famous for","Soft Drink"]
["Maggi","Famous for","Noodles"]
["Subway","Famous for","Sandwich"]
["Starbucks","Famous for","Coffee"]
["Buffalo Wild Wings","Famous for","Steak"]

{"sheet":"Table List","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Creating List from Table"]
[]
[null,"Brand","Famous for"]
[null,"Pizza Hut","Pizza"]
[null,"KFC","Chicken Fry"]
[null,"McDonald's","Burger"]
[null,"Pepsi","Soft Drink"]
[null,"Maggi","Noodles"]
[null,"Subway","Sandwich"]
[null,"Starbucks","Coffee"]
[null,"Buffalo Wild Wings","Steak"]

{"sheet":"Multiple selections","index":6,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"List with Multiple Selections"]
[]
[null,"Brand",null,"Drop-Down List"]
[null,"Pizza Hut",null,"KFC, McDonald's, KFC"]
[null,"KFC"]
[null,"McDonald's"]
[null,"Pepsi"]
[null,"Maggi"]
[null,"Subway"]
[null,"Starbucks"]
[null,"Buffalo Wild Wings"]
[null,"Jolee Bee"]
[null,"Nestle"]
[null,"Nescafe"]
[null,"Cheetos"]