{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["data","IF","merge","Table1","power","table2","pivot table","consolidate","vba","practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"data","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"ABC\" Company"]
[]
[null,"Product","Salesperson","Sales"]
[null,"Orange","Michael",3929]
[null,"Kiwi","Sheldon",4142]
[null,"Tomato","Richard",1036]
[null,"Apple","Robin",4013]
[null,"Kiwi","Emily",3672]
[null,"Strawberry","Leonard",4395]
[null,"Apple","Jefferson",1605]
[null,"Orange","Amy",3634]

{"sheet":"IF","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"IF Function"]
[]
[null,"Product","Salesperson","Combined Names","Helper"]
[null,"Apple","Robin",{"$f":"IF(B5=B4,D4&\", \"&C5,C5)","v":"Robin"},{"$f":"IF(B6<>B5,\"useful\",\"\")","v":""}]
[null,"Apple","Jefferson",{"$f":"IF(B6=B5,D5&\", \"&C6,C6)","v":"Robin, Jefferson"},{"$f":"IF(B7<>B6,\"useful\",\"\")","v":"useful"}]
[null,"Kiwi","Sheldon","Sheldon",""]
[null,"Kiwi","Emily","Sheldon, Emily","useful"]
[null,"Orange","Michael","Michael",""]
[null,"Orange","Amy","Michael, Amy","useful"]
[null,"Strawberry","Leonard","Leonard","useful"]
[null,"Tomato","Richard","Richard","useful"]

{"sheet":"merge","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,5,1],[6,1,7,1],[8,1,9,1]]}
[]
[null,"Using Merge & Center Option"]
[]
[null,"Product","Salesperson","Sales"]
[null,"Apple","Robin",4013]
[null,null,"Jefferson",1605]
[null,"Kiwi","Sheldon",4142]
[null,null,"Emily",3672]
[null,"Orange","Michael",3929]
[null,null,"Amy",3634]
[null,"Strawberry","Leonard",4395]
[null,"Tomato","Richard",1036]

{"sheet":"Table1","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Product","Count"]
["Orange",2]
["Kiwi",2]
["Tomato",1]
["Apple",2]
["Strawberry",1]

{"sheet":"power","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Power Query"]
[]
[null,"Product","Salesperson","Sales"]
[null,"Orange","Michael",3929]
[null,"Kiwi","Sheldon",4142]
[null,"Tomato","Richard",1036]
[null,"Apple","Robin",4013]
[null,"Kiwi","Emily",3672]
[null,"Strawberry","Leonard",4395]
[null,"Apple","Jefferson",1605]
[null,"Orange","Amy",3634]

{"sheet":"table2","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Row Labels","Sum of Sales"]
[null,"Apple",5618]
[null,"Kiwi",7814]
[null,"Orange",7563]
[null,"Strawberry",4395]
[null,"Tomato",1036]
[null,"Grand Total",26426]

{"sheet":"pivot table","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Pivot Table"]
[]
[null,"Product","Sales"]
[null,"Orange",3929]
[null,"Kiwi",4142]
[null,"Tomato",1036]
[null,"Apple",4013]
[null,"Kiwi",3672]
[null,"Strawberry",4395]
[null,"Apple",1605]
[null,"Orange",3634]

{"sheet":"consolidate","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Consolidate Option"]
[]
[null,"Product","Sales",null,"Product","Sales"]
[null,"Orange",3929,null,"Orange",7563]
[null,"Kiwi",4142,null,"Kiwi",7814]
[null,"Tomato",1036,null,"Tomato",1036]
[null,"Apple",4013,null,"Apple",5618]
[null,"Kiwi",3672,null,"Strawberry",4395]
[null,"Strawberry",4395]
[null,"Apple",1605]
[null,"Orange",3634]

{"sheet":"vba","index":8,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"VBA Code"]
[]
[null,"Product","Sales"]
[null,"Tomato",1036]
[null,"Apple",5618]
[null,"Kiwi",3672]
[null,"Strawberry",4395]
[null,"Orange",3634]

{"sheet":"practice","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Product","Salesperson","Sales"]
[null,"Orange","Michael",3929]
[null,"Kiwi","Sheldon",4142]
[null,"Tomato","Richard",1036]
[null,"Apple","Robin",4013]
[null,"Kiwi","Emily",3672]
[null,"Strawberry","Leonard",4395]
[null,"Apple","Jefferson",1605]
[null,"Orange","Amy",3634]