{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["SingleToSingle","MultiToMultiForm","SinToSinForm","MultiToMulti","SingleToMulti","CellRef","INDIRECT and COLUMN Functions","INDEX","Power Query","VBA"],"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":"SingleToSingle","index":0,"n_rows":13,"n_cols":21,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Transposing Single Column",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[]
[]
[null,"Number",1,2,3,4,5,6]

{"sheet":"MultiToMultiForm","index":1,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,17,1,18],[1,1,1,7]]}
[]
[null,"Transposing Multiple Columns",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Odd Number","Even Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odd Number","Even Number"]
[null,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2]
[null,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4]
[null,5,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6]
[null,7,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8]
[null,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,10]
[null,11,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,12]
[]
[]
[null,"Odd Number",1,3,5,7,9,11]
[null,"Even Number",2,4,6,8,10,12]

{"sheet":"SinToSinForm","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using TRANSPOSE Function for Single Column  "]
[]
[null,"Number"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[]
[]
[null,{"$f":"TRANSPOSE(B4:B10)","v":"Number"},1,2,3,4,5,6]

{"sheet":"MultiToMulti","index":3,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,17,1,18],[1,1,1,5]]}
[]
[null,"Using TRANSPOSE Function for Multiple Columns  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Odd Number","Even Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odd Number","Even Number"]
[null,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2]
[null,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4]
[null,5,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6]
[null,7,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,10]
[]
[null,{"$f":"TRANSPOSE(B4:C8)","v":"Odd Number"},1,3,5,7]
[null,"Even Number",2,4,6,8]

{"sheet":"SingleToMulti","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,1,17,1],[1,1,1,6]]}
[]
[null,"Combining OFFSET, COLUMNS, ROW Functions"]
[]
[null,"Number"]
[null,1]
[null,11]
[null,111]
[null,1111]
[null,11111]
[null,2]
[null,22]
[null,222]
[null,2222]
[null,22222]
[]
[]
[null,"Number",{"$f":"OFFSET($B$5,COLUMNS($B:B)-1+(ROWS($5:5)-1)*5,0)","v":1},{"$f":"OFFSET($B$5,COLUMNS($B:C)-1+(ROWS($5:5)-1)*5,0)","v":11},{"$f":"OFFSET($B$5,COLUMNS($B:D)-1+(ROWS($5:5)-1)*5,0)","v":111},{"$f":"OFFSET($B$5,COLUMNS($B:E)-1+(ROWS($5:5)-1)*5,0)","v":1111},{"$f":"OFFSET($B$5,COLUMNS($B:F)-1+(ROWS($5:5)-1)*5,0)","v":11111}]
[null,null,{"$f":"OFFSET($B$5,COLUMNS($B:B)-1+(ROWS($5:6)-1)*5,0)","v":2},{"$f":"OFFSET($B$5,COLUMNS($B:C)-1+(ROWS($5:6)-1)*5,0)","v":22},{"$f":"OFFSET($B$5,COLUMNS($B:D)-1+(ROWS($5:6)-1)*5,0)","v":222},{"$f":"OFFSET($B$5,COLUMNS($B:E)-1+(ROWS($5:6)-1)*5,0)","v":2222},{"$f":"OFFSET($B$5,COLUMNS($B:F)-1+(ROWS($5:6)-1)*5,0)","v":22222}]

{"sheet":"CellRef","index":5,"n_rows":14,"n_cols":20,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,18,1,19],[1,1,1,7]]}
[]
[null,"Applying Cell Reference",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Odd Number","Even Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odd Number","Even Number"]
[null,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2]
[null,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4]
[null,5,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6]
[null,7,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8]
[null,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,10]
[null,11,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,12]
[]
[]
[null,{"$f":"B4","v":"Odd Number"},{"$f":"B5","v":1},{"$f":"B6","v":3},{"$f":"B7","v":5},{"$f":"B8","v":7},{"$f":"B9","v":9},{"$f":"B10","v":11}]
[null,{"$f":"C4","v":"Even Number"},{"$f":"C5","v":2},{"$f":"C6","v":4},{"$f":"C7","v":6},{"$f":"C8","v":8},{"$f":"C9","v":10},{"$f":"C10","v":12}]

{"sheet":"INDIRECT and COLUMN Functions","index":6,"n_rows":8,"n_cols":18,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,16,1,17]]}
[]
[null,"Combining INDIRECT and COLUMN Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Odd Number","Even Number",null,"Odd Number",{"$f":"INDIRECT(\"b\"&COLUMN()-1)","v":1},{"$f":"INDIRECT(\"b\"&COLUMN()-1)","v":3},{"$f":"INDIRECT(\"b\"&COLUMN()-1)","v":5},{"$f":"INDIRECT(\"b\"&COLUMN()-1)","v":7},null,null,null,null,null,null,null,"Odd Number","Even Number"]
[null,1,2,null,"Even Number",{"$f":"INDIRECT(\"c\"&COLUMN()-1)","v":2},{"$f":"INDIRECT(\"c\"&COLUMN()-1)","v":4},{"$f":"INDIRECT(\"c\"&COLUMN()-1)","v":6},{"$f":"INDIRECT(\"c\"&COLUMN()-1)","v":8},null,null,null,null,null,null,null,1,2]
[null,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4]
[null,5,6,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6]
[null,7,8,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8]

{"sheet":"INDEX","index":7,"n_rows":8,"n_cols":18,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,16,1,17]]}
[]
[null,"Combining INDEX and COLUMN Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Odd Number","Even Number",null,"Odd Number",{"$f":"INDEX($B$4:$C$11,COLUMN()-4,1)","v":1},{"$f":"INDEX($B$4:$C$11,COLUMN()-4,1)","v":3},{"$f":"INDEX($B$4:$C$11,COLUMN()-4,1)","v":5},{"$f":"INDEX($B$4:$C$11,COLUMN()-4,1)","v":7},null,null,null,null,null,null,null,"Odd Number","Even Number"]
[null,1,2,null,"Even Number",{"$f":"INDEX($B$4:$C$11,COLUMN()-4,2)","v":2},{"$f":"INDEX($B$4:$C$11,COLUMN()-4,2)","v":4},{"$f":"INDEX($B$4:$C$11,COLUMN()-4,2)","v":6},{"$f":"INDEX($B$4:$C$11,COLUMN()-4,2)","v":8},null,null,null,null,null,null,null,1,2]
[null,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4]
[null,5,6,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6]
[null,7,8,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8]

{"sheet":"Power Query","index":8,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of Power Query",null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Odd Number","Even Number",null,"Column1","Column2","Column3","Column4","Column5","Column6","Column7",null,null,null,null,"Odd Number","Even Number"]
[null,1,2,null,1,3,5,7,9,11,13,null,null,null,null,1,2]
[null,3,4,null,2,4,6,8,10,12,14,null,null,null,null,3,4]
[null,5,6,null,null,null,null,null,null,null,null,null,null,null,null,5,6]
[null,7,8,null,null,null,null,null,null,null,null,null,null,null,null,7,8]
[null,9,10,null,null,null,null,null,null,null,null,null,null,null,null,9,10]
[null,11,12,null,null,null,null,null,null,null,null,null,null,null,null,11,12]
[null,13,14,null,null,null,null,null,null,null,null,null,null,null,null,13,14]

{"sheet":"VBA","index":9,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,18,1,19]]}
[]
[null,"Inserting VBA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Odd Number","Even Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odd Number","Even Number"]
[null,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2]
[null,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4]
[null,5,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,6]
[null,7,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8]
[null,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,10]
[]
[null,"Odd Number",1,3,5,7,9]
[null,"Even Number",2,4,6,8,10]