{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["dataset","vba & Transpose","vba & rows","filterxml","TextToColumn","Table1","power query","vba","diy"],"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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null," Split Text into Multiple Rows"]
[]
[null,"Code","Product; Brand; Price"]
[null,"01PL","Laptop; Dell; 500.00$"]
[null,"31WQ","Smartphone; ASUS; 300.00$"]
[null,"24AD","Processor; Core i3; 200.00$"]
[null,"11KT","Laptop; HP; 550.00$"]

{"sheet":"vba & Transpose","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,4],[1,1,1,4],[5,1,5,4]]}
[]
[null,"Using VBA & TRANSPOSE Function"]
[]
[null,"Product; Brand; Price"]
[null,"Laptop; Dell; 500.00$","Smartphone; ASUS; 300.00$","Processor; Core i3; 200.00$","Laptop; HP; 550.00$"]
[null,"Splitted Data"]
[null,{"$f":"TRANSPOSE(TextSplit(B5,\";\"))","v":"Laptop"},{"$f":"TRANSPOSE(TextSplit(C5,\";\"))","v":"Smartphone"},{"$f":"TRANSPOSE(TextSplit(D5,\";\"))","v":"Processor"},{"$f":"TRANSPOSE(TextSplit(E5,\";\"))","v":"Laptop"}]
[null," Dell"," ASUS"," Core i3"," HP"]
[null," 500.00$"," 300.00$"," 200.00$"," 550.00$"]

{"sheet":"vba & rows","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[5,1,5,4]]}
[]
[null,"Using VBA & ROWS Function"]
[]
[null,"Product; Brand; Price"]
[null,"Laptop; Dell; 500.00$","Smartphone; ASUS; 300.00$","Processor; Core i3; 200.00$","Laptop; HP; 550.00$"]
[null,"Splitted Data"]
[null,{"$f":"TextSplitManual(B$5,\";\",ROWS($B$5:B5))","v":"Laptop"},{"$f":"TextSplitManual(C$5,\";\",ROWS($B$5:C5))","v":"Smartphone"},{"$f":"TextSplitManual(D$5,\";\",ROWS($B$5:D5))","v":"Processor"},{"$f":"TextSplitManual(E$5,\";\",ROWS($B$5:E5))","v":"Laptop"}]
[null,{"$f":"TextSplitManual(B$5,\";\",ROWS($B$5:B6))","v":" Dell"},{"$f":"TextSplitManual(C$5,\";\",ROWS($B$5:C6))","v":" ASUS"},{"$f":"TextSplitManual(D$5,\";\",ROWS($B$5:D6))","v":" Core i3"},{"$f":"TextSplitManual(E$5,\";\",ROWS($B$5:E6))","v":" HP"}]
[null,{"$f":"TextSplitManual(B$5,\";\",ROWS($B$5:B7))","v":" 500.00$"},{"$f":"TextSplitManual(C$5,\";\",ROWS($B$5:C7))","v":" 300.00$"},{"$f":"TextSplitManual(D$5,\";\",ROWS($B$5:D7))","v":" 200.00$"},{"$f":"TextSplitManual(E$5,\";\",ROWS($B$5:E7))","v":" 550.00$"}]

{"sheet":"filterxml","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[5,1,5,4]]}
[]
[null,"Using FILTERXML & SUBSTITUTE Functions"]
[]
[null,"Product; Brand; Price"]
[null,"Laptop; Dell; 500.00$","Smartphone; ASUS; 300.00$","Processor; Core i3; 200.00$","Laptop; HP; 550.00$"]
[null,"Splitted Data"]
[null,{"$f":"_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(B5,\";\", \"</s><s>\") & \"</s></t>\", \"//s\")","v":"Laptop"},{"$f":"_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(C5,\";\", \"</s><s>\") & \"</s></t>\", \"//s\")","v":"Smartphone"},{"$f":"_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(D5,\";\", \"</s><s>\") & \"</s></t>\", \"//s\")","v":"Processor"},{"$f":"_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(E5,\";\", \"</s><s>\") & \"</s></t>\", \"//s\")","v":"Laptop"}]
[null,"Dell","ASUS","Core i3","HP"]
[null,"500.00$","300.00$","200.00$","550.00$"]

{"sheet":"TextToColumn","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Text to Column Wizard"]
[]
[null,"Code","Product"," Brand"," Price"]
[null,"01PL","Laptop"," Dell"," 500.00$"]
[null,"31WQ","Smartphone"," ASUS"," 300.00$"]
[null,"24AD","Processor"," Core i3"," 200.00$"]
[null,"11KT","Laptop"," HP"," 550.00$"]
[]
[null,{"$f":"TRANSPOSE(C4:E8)","v":"Product"},"Laptop","Smartphone","Processor","Laptop"]
[null," Brand"," Dell"," ASUS"," Core i3"," HP"]
[null," Price"," 500.00$"," 300.00$"," 200.00$"," 550.00$"]

{"sheet":"Table1","index":5,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Code","Product; Brand; Price"]
["01PL","Laptop"]
["01PL"," Dell"]
["01PL"," 500.00$"]
["31WQ","Smartphone"]
["31WQ"," ASUS"]
["31WQ"," 300.00$"]
["24AD","Processor"]
["24AD"," Core i3"]
["24AD"," 200.00$"]
["11KT","Laptop"]
["11KT"," HP"]
["11KT"," 550.00$"]

{"sheet":"power query","index":6,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Power Query Editor"]
[]
[null,"Code","Product; Brand; Price"]
[null,"01PL","Laptop; Dell; 500.00$"]
[null,"31WQ","Smartphone; ASUS; 300.00$"]
[null,"24AD","Processor; Core i3; 200.00$"]
[null,"11KT","Laptop; HP; 550.00$"]

{"sheet":"vba","index":7,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Code","Product; Brand; Price"]
[null,"01PL","Laptop"]
[null,null," Dell"]
[null,null," 500.00$"]
[null,"31WQ","Smartphone"]
[null,null," ASUS"]
[null,null," 300.00$"]
[null,"24AD","Processor"]
[null,null," Core i3"]
[null,null," 200.00$"]
[null,"11KT","Laptop"]
[null,null," HP"]
[null,null," 550.00$"]

{"sheet":"diy","index":8,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Do It Yourself"]
[]
[null,"Code","Product; Brand; Price"]
[null,"01PL","Laptop; Dell; 500.00$"]
[null,"31WQ","Smartphone; ASUS; 300.00$"]
[null,"24AD","Processor; Core i3; 200.00$"]
[null,"11KT","Laptop; HP; 550.00$"]