{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","PROPER","VBA","Table2","PowerQuery","Flash Fill"],"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Change to Title Case"]
[]
[null,"Name","Converted"]
[null,"alex morgan"]
[null,"jack rossie"]
[null,"bob miller"]
[null,"mike athurton"]
[null,"sam billings"]
[null,"cristiano ronaldo"]

{"sheet":"PROPER","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of PROPER Function",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Converted",null,null,null,null,null,"Name","Converted"]
[null,"alex morgan",{"$f":"PROPER(B5)","v":"Alex Morgan"},null,null,null,null,null,"alex morgan"]
[null,"jack rossie",{"$f":"PROPER(B6)","v":"Jack Rossie"},null,null,null,null,null,"jack rossie"]
[null,"bob miller","Bob Miller",null,null,null,null,null,"bob miller"]
[null,"mike athurton","Mike Athurton",null,null,null,null,null,"mike athurton"]
[null,"sam billings","Sam Billings",null,null,null,null,null,"sam billings"]
[null,"cristiano ronaldo","Cristiano Ronaldo",null,null,null,null,null,"cristiano ronaldo"]

{"sheet":"VBA","index":2,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Converted",null,null,null,null,null,"Name","Converted"]
[null,"alex morgan","Alex Morgan",null,null,null,null,null,"alex morgan"]
[null,"jack rossie","Jack Rossie",null,null,null,null,null,"jack rossie"]
[null,"bob miller","Bob Miller",null,null,null,null,null,"bob miller"]
[null,"mike athurton","Mike Athurton",null,null,null,null,null,"mike athurton"]
[null,"sam billings","Sam Billings",null,null,null,null,null,"sam billings"]
[null,"cristiano ronaldo","Cristiano Ronaldo",null,null,null,null,null,"cristiano ronaldo"]

{"sheet":"Table2","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","Converted"]
["alex morgan","Alex Morgan"]
["jack rossie","Jack Rossie"]
["bob miller","Bob Miller"]
["mike athurton","Mike Athurton"]
["sam billings","Sam Billings"]
["cristiano ronaldo","Cristiano Ronaldo"]

{"sheet":"PowerQuery","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of PowerQuery",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Converted",null,null,null,null,null,"Name","Converted"]
[null,"alex morgan","alex morgan",null,null,null,null,null,"alex morgan"]
[null,"jack rossie","jack rossie",null,null,null,null,null,"jack rossie"]
[null,"bob miller","bob miller",null,null,null,null,null,"bob miller"]
[null,"mike athurton","mike athurton",null,null,null,null,null,"mike athurton"]
[null,"sam billings","sam billings",null,null,null,null,null,"sam billings"]
[null,"cristiano ronaldo","cristiano ronaldo",null,null,null,null,null,"cristiano ronaldo"]

{"sheet":"Flash Fill","index":5,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of Flash Fill Feature",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Converted",null,null,null,null,null,"Name","Converted"]
[null,"alex morgan","Alex Morgan",null,null,null,null,null,"alex morgan"]
[null,"jack rossie","Jack Rossie",null,null,null,null,null,"jack rossie"]
[null,"bob miller","Bob Miller",null,null,null,null,null,"bob miller"]
[null,"mike athurton","Mike Athurton",null,null,null,null,null,"mike athurton"]
[null,"sam billings","Sam Billings",null,null,null,null,null,"sam billings"]
[null,"cristiano ronaldo","Cristiano Ronaldo",null,null,null,null,null,"cristiano ronaldo"]