{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","IF & CONCATENATE","Consolidate","VBA","Practice"],"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":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combine Data"]
[]
[null,"Name","Products"]
[null,"Alex Morgan","Laptop"]
[null,"Alex Morgan","Refridgerator"]
[null,"Alex Morgan","AC"]
[null,"Graeme Smith","Mobile"]
[null,"Mike Tyson","Furniture"]
[null,"Mike Henry","Television"]
[null,"Rafael Wood","Laptop"]
[null,"Rafael Wood","Refridgerator"]
[null,"Doris Lessing","AC"]
[null,"Mathew Orwell","Mobile"]

{"sheet":"IF & CONCATENATE","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combine Data"]
[]
[null,"Name","Products","Intermediate Column","Final List"]
[null,"Alex Morgan","Laptop",{"$f":"IF(B5=B4,D4&\",\"&C5,C5)","v":"Laptop"},{"$f":"IF(B5<>B6,CONCATENATE(B5,\" \",\"sold\",\" \",D5),\"\")","v":""}]
[null,"Alex Morgan","Refridgerator",{"$f":"IF(B6=B5,D5&\",\"&C6,C6)","v":"Laptop,Refridgerator"},{"$f":"IF(B6<>B7,CONCATENATE(B6,\" \",\"sold\",\" \",D6),\"\")","v":""}]
[null,"Alex Morgan","AC","Laptop,Refridgerator,AC","Alex Morgan sold Laptop,Refridgerator,AC"]
[null,"Graeme Smith","Mobile","Mobile","Graeme Smith sold Mobile"]
[null,"Mike Tyson","Furniture","Furniture","Mike Tyson sold Furniture"]
[null,"Mike Henry","Television","Television","Mike Henry sold Television"]
[null,"Rafael Wood","Laptop","Laptop",""]
[null,"Rafael Wood","Refridgerator","Laptop,Refridgerator","Rafael Wood sold Laptop,Refridgerator"]
[null,"Doris Lessing","AC","AC","Doris Lessing sold AC"]
[null,"Mathew Orwell","Mobile","Mobile","Mathew Orwell sold Mobile"]

{"sheet":"Consolidate","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combine Data"]
[]
[null,"Name","Products","Selling Price",null,"Name","Total SP"]
[null,"Alex Morgan","Laptop",1087,null,"Alex Morgan",2922]
[null,"Alex Morgan","Refridgerator",983,null,"Graeme Smith",1172]
[null,"Alex Morgan","AC",852,null,"Mike Tyson",795]
[null,"Graeme Smith","Mobile",1172,null,"Mike Henry",962]
[null,"Mike Tyson","Furniture",795,null,"Rafael Wood",1991]
[null,"Mike Henry","Television",962,null,"Doris Lessing",1011]
[null,"Rafael Wood","Laptop",1122,null,"Mathew Orwell",791]
[null,"Rafael Wood","Refridgerator",869]
[null,"Doris Lessing","AC",1011]
[null,"Mathew Orwell","Mobile",791]

{"sheet":"VBA","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combine Data"]
[]
[null,"Name","Products",null,"Name","Products"]
[null,"Alex Morgan","Laptop",null,"Alex Morgan"," Laptop, Refridgerator, AC"]
[null,"Alex Morgan","Refridgerator",null,"Graeme Smith"," Mobile"]
[null,"Alex Morgan","AC",null,"Mike Tyson"," Furniture"]
[null,"Graeme Smith","Mobile",null,"Mike Henry"," Television"]
[null,"Mike Tyson","Furniture",null,"Rafael Wood"," Laptop, Refridgerator"]
[null,"Mike Henry","Television",null,"Doris Lessing"," AC"]
[null,"Rafael Wood","Laptop",null,"Mathew Orwell"," Mobile"]
[null,"Rafael Wood","Refridgerator"]
[null,"Doris Lessing","AC"]
[null,"Mathew Orwell","Mobile"]

{"sheet":"Practice","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Do Yourself"]
[]
[null,"Name","Products"]
[null,"Alex Morgan","Laptop"]
[null,"Alex Morgan","Refridgerator"]
[null,"Alex Morgan","AC"]
[null,"Graeme Smith","Mobile"]
[null,"Mike Tyson","Furniture"]
[null,"Mike Henry","Television"]
[null,"Rafael Wood","Laptop"]
[null,"Rafael Wood","Refridgerator"]
[null,"Doris Lessing","AC"]
[null,"Mathew Orwell","Mobile"]