{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["VBA","TextToColumns","FILTERXML","Power Query"],"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":"VBA","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"How,to,split,data,from,one,cell,into,multiple,rows,in,excel"]
[]
[null,"How"]
[null,"to"]
[null,"split"]
[null,"data"]
[null,"from"]
[null,"one"]
[null,"cell"]
[null,"into"]
[null,"multiple"]
[null,"rows"]
[null,"in"]
[null,"excel"]

{"sheet":"TextToColumns","index":1,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"How,to,split,data,from,one,cell,into,multiple,rows,in,excel"]
[]
[null,"How"]
[null,"to"]
[null,"split"]
[null,"data"]
[null,"from"]
[null,"one"]
[null,"cell"]
[null,"into"]
[null,"multiple"]
[null,"rows"]
[null,"in"]
[null,"excel"]

{"sheet":"FILTERXML","index":2,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"How,to,split,data,from,one,cell,into,multiple,rows,in,excel"]
[]
[null,{"$f":"_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE($B$2,\",\", \"</s><s>\") & \"</s></t>\", \"//s\")","v":"How"}]
[null,"to"]
[null,"split"]
[null,"data"]
[null,"from"]
[null,"one",null,null,null,null,null,null,null,null,null,null,null,"FILTERXML(\"<t><s>\" &SUBSTITUTE($B$2,\",\", \"</s><s>\") & \"</s></t>\", \"//s\")"]
[null,"cell"]
[null,"into"]
[null,"multiple"]
[null,"rows"]
[null,"in"]
[null,"excel"]

{"sheet":"Power Query","index":3,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Column1"]
[null,"How,to,split,data,from,one,cell,into,multiple,rows,in,excel"]
[]
[null,"Column1"]
[null,"How"]
[null,"to"]
[null,"split"]
[null,"data"]
[null,"from"]
[null,"one"]
[null,"cell"]
[null,"into"]
[null,"multiple"]
[null,"rows"]
[null,"in"]
[null,"excel"]