{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset 1","FILTERXML and SUBSTITUTE ","Dataset 2","Text to Column Option","Remove Consolidation Reference"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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 1","index":0,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset"]
[]
[null,"Country","USA","England","India"]
[null,"City","Chicago, Austin, Seattle","Manchester, London, Southampton","Mumbai, Delhi, Bangalore"]

{"sheet":"FILTERXML and SUBSTITUTE ","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,1,9,1],[1,1,1,4],[2,11,2,14]]}
[]
[null,"Applying FILTERXML and SUBSTITUTE Functions"]
[null,null,null,null,null,null,null,null,null,null,null,"Do Yourself"]
[null,"Country","USA","England","India"]
[null,"City","Chicago, Austin, Seattle","Manchester, London, Southampton","Mumbai, Delhi, Bangalore",null,null,null,null,null,null,"Country","USA","England","India"]
[null,null,null,null,null,null,null,null,null,null,null,"City","Chicago, Austin, Seattle","Manchester, London, Southampton","Mumbai, Delhi, Bangalore"]
[null,"Country","USA","England","India"]
[null,"City",{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(C5,\",\",\"</s><s>\")&\"</s></t>\",\"//s\")","v":"Chicago"},{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(D5,\",\",\"</s><s>\")&\"</s></t>\",\"//s\")","v":"Manchester"},{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(E5,\",\",\"</s><s>\")&\"</s></t>\",\"//s\")","v":"Mumbai"}]
[null,null,"Austin","London","Delhi"]
[null,null,"Seattle","Southampton","Bangalore"]

{"sheet":"Dataset 2","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Country","Cities"]
[null,"USA","Chicago, Austin, Seattle"]
[null,"England","Manchester, London, Southampton"]
[null,"India","Mumbai, Delhi, Bangalore"]

{"sheet":"Text to Column Option","index":3,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using Text to Column Wizard",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Country","Cities","City 1","City 2","City 3",null,null,null,null,null,"Country","Cities","City 1","City 2","City 3"]
[null,"USA","Chicago, Austin, Seattle","Chicago"," Austin"," Seattle",null,null,null,null,null,"USA","Chicago, Austin, Seattle"]
[null,"England","Manchester, London, Southampton","Manchester"," London"," Southampton",null,null,null,null,null,"England","Manchester, London, Southampton"]
[null,"India","Mumbai, Delhi, Bangalore","Mumbai"," Delhi"," Bangalore",null,null,null,null,null,"India","Mumbai, Delhi, Bangalore"]

{"sheet":"Remove Consolidation Reference","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Consolidation Reference"]
[]
[null,"Sales Person","Sales Amount"]
[null,"Adam",120]
[null,"Chris",10]
[null,"Layla",25]
[null,"Chris",60]
[null,"Layla",76]
[null,"Adam",13]
[null,"Chris",35]
[null,"Chris",50]