{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Sheet1","Sheet3","Query","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":3,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2097]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Hermann / Pixabay"]

{"sheet":"Sheet1","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Transaction Number","Date","Quantity","Product","Product(s) in Bundle","Ship Method","Customer"]
[1001,"2017-05-20",2,"Formula Bundle","Ctrl+Shift+Enter;DAX Formula for Power Pivot;Learn to Write DAX","Fdx G","@28flyersfan "]
[1002,"2017-05-20",2,"Power Excel Bundle","MrExcel XL;Power Excel 2017 Edition","Fdx G","@aalannyse"]
[1003,"2017-05-20",1,"Power BI Bundle","M is for (Data) Monkey;Power Pivot & Power BI;Learn to Write DAX","Fdx G","@Adovy"]
[1004,"2017-05-20",1,"XL Book","MrExcel XL","Fdx G","@algaegirl328"]
[1005,"2017-05-20",1,"Formula Bundle","Ctrl+Shift+Enter;DAX Formula for Power Pivot;Learn to Write DAX","Media Mail","@alliebp"]
[1006,"2017-05-20",1,"Power Excel Bundle","MrExcel XL;Power Excel 2017 Edition","Fdx G","@anarchival"]
[1007,"2017-05-20",1,"Power BI Bundle","M is for (Data) Monkey;Power Pivot & Power BI;Learn to Write DAX","Fdx G","@awellofcards"]
[1008,"2017-05-20",3,"XL Book","MrExcel XL","Fdx G","@beanbeannie"]
[1009,"2017-05-20",2,"Formula Bundle","Ctrl+Shift+Enter;DAX Formula for Power Pivot;Learn to Write DAX","Fdx G","@BeingHanuman"]
[1010,"2017-05-20",1,"Power Excel Bundle","MrExcel XL;Power Excel 2017 Edition","Fdx G","@bethykins"]
[1011,"2017-05-20",3,"Power BI Bundle","M is for (Data) Monkey;Power Pivot & Power BI;Learn to Write DAX","Fdx G","@bouleg812"]

{"sheet":"Sheet3","index":2,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Transaction Number","Date","Quantity","Product","Product(s) in Bundle","Ship Method","Customer"]
[1001,"2017-05-20",2,"Formula Bundle","Ctrl+Shift+Enter","Fdx G","@28flyersfan "]
[1001,"2017-05-20",2,"Formula Bundle","DAX Formula for Power Pivot","Fdx G","@28flyersfan "]
[1001,"2017-05-20",2,"Formula Bundle","Learn to Write DAX","Fdx G","@28flyersfan "]
[1002,"2017-05-20",2,"Power Excel Bundle","MrExcel XL","Fdx G","@aalannyse"]
[1002,"2017-05-20",2,"Power Excel Bundle","Power Excel 2017 Edition","Fdx G","@aalannyse"]
[1003,"2017-05-20",1,"Power BI Bundle","M is for (Data) Monkey","Fdx G","@Adovy"]
[1003,"2017-05-20",1,"Power BI Bundle","Power Pivot & Power BI","Fdx G","@Adovy"]
[1003,"2017-05-20",1,"Power BI Bundle","Learn to Write DAX","Fdx G","@Adovy"]
[1004,"2017-05-20",1,"XL Book","MrExcel XL","Fdx G","@algaegirl328"]
[1005,"2017-05-20",1,"Formula Bundle","Ctrl+Shift+Enter","Media Mail","@alliebp"]
[1005,"2017-05-20",1,"Formula Bundle","DAX Formula for Power Pivot","Media Mail","@alliebp"]
[1005,"2017-05-20",1,"Formula Bundle","Learn to Write DAX","Media Mail","@alliebp"]
[1006,"2017-05-20",1,"Power Excel Bundle","MrExcel XL","Fdx G","@anarchival"]
[1006,"2017-05-20",1,"Power Excel Bundle","Power Excel 2017 Edition","Fdx G","@anarchival"]
[1007,"2017-05-20",1,"Power BI Bundle","M is for (Data) Monkey","Fdx G","@awellofcards"]
[1007,"2017-05-20",1,"Power BI Bundle","Power Pivot & Power BI","Fdx G","@awellofcards"]
[1007,"2017-05-20",1,"Power BI Bundle","Learn to Write DAX","Fdx G","@awellofcards"]
[1008,"2017-05-20",3,"XL Book","MrExcel XL","Fdx G","@beanbeannie"]
[1009,"2017-05-20",2,"Formula Bundle","Ctrl+Shift+Enter","Fdx G","@BeingHanuman"]
[1009,"2017-05-20",2,"Formula Bundle","DAX Formula for Power Pivot","Fdx G","@BeingHanuman"]
[1009,"2017-05-20",2,"Formula Bundle","Learn to Write DAX","Fdx G","@BeingHanuman"]
[1010,"2017-05-20",1,"Power Excel Bundle","MrExcel XL","Fdx G","@bethykins"]
[1010,"2017-05-20",1,"Power Excel Bundle","Power Excel 2017 Edition","Fdx G","@bethykins"]
[1011,"2017-05-20",3,"Power BI Bundle","M is for (Data) Monkey","Fdx G","@bouleg812"]
[1011,"2017-05-20",3,"Power BI Bundle","Power Pivot & Power BI","Fdx G","@bouleg812"]
[1011,"2017-05-20",3,"Power BI Bundle","Learn to Write DAX","Fdx G","@bouleg812"]

{"sheet":"Query","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Wrap Up","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Dustin has a column with 1 to 16 values separated by ;"]
[null,"There are 8 columns total in the data"]
[null,"He wants the ; separated to rows"]
[null,"The May 2017 update to Power Query adds the ability to split a column to Rows"]