{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","paste-special","Keyboard","TRANSPOSE","OFFSET","INDIRECT","INDEX","XLOOKUP","Find-Replace","PowerQuery","VBA","Overview"],"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":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Transpose in Excel",null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,"April",16546,35654,65413]

{"sheet":"paste-special","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using Paste-Special Tool",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,null,"April",16546,35654,65413]
[]
[null,"Sale'2023","January","Fabruary","March","April"]
[null,"Texas",10350,16564,20156,16546]
[null,"New York",15630,17865,21354,35654]
[null,"Boston",15984,16420,16546,65413]

{"sheet":"Keyboard","index":2,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using keyboard Shortcut",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,null,"April",16546,35654,65413]
[]
[]
[null,"Sale'2023","January","Fabruary","March","April"]
[null,"Texas",10350,16564,20156,16546]
[null,"New York",15630,17865,21354,35654]
[null,"Boston",15984,16420,16546,65413]

{"sheet":"TRANSPOSE","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using TRANSPOSE Function",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,null,"April",16546,35654,65413]
[]
[null,{"$f":"TRANSPOSE(B4:E8)","v":"Sale'2023"},"January","Fabruary","March","April"]
[null,"Texas",10350,16564,20156,16546]
[null,"New York",15630,17865,21354,35654]
[null,"Boston",15984,16420,16546,65413]

{"sheet":"OFFSET","index":4,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using OFFSET Function",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,null,"April",16546,35654,65413]
[]
[null,0,1,2,3,4]
[0,{"$f":"OFFSET($B$4,B$10,$A11)","v":"Sale'2023"},{"$f":"OFFSET($B$4,C$10,$A11)","v":"January"},"Fabruary","March","April"]
[1,{"$f":"OFFSET($B$4,B$10,$A12)","v":"Texas"}]
[2,"New York"]
[3,"Boston"]

{"sheet":"INDIRECT","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Combining INDIRECT and COLUMN Functions",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,"April",16546,35654,65413]
[]
[]
[null,{"$f":"INDIRECT(\"B\"&COLUMN()+2)","v":"Sale'2023"},{"$f":"INDIRECT(\"B\"&COLUMN()+2)","v":"January"},{"$f":"INDIRECT(\"B\"&COLUMN()+2)","v":"Fabruary"},{"$f":"INDIRECT(\"B\"&COLUMN()+2)","v":"March"},{"$f":"INDIRECT(\"B\"&COLUMN()+2)","v":"April"}]
[{"$f":"_xlfn.FORMULATEXT(B12)","v":"=INDIRECT(\"C\"&COLUMN()+2)"},{"$f":"INDIRECT(\"C\"&COLUMN()+2)","v":"Texas"},{"$f":"INDIRECT(\"C\"&COLUMN()+2)","v":10350},{"$f":"INDIRECT(\"C\"&COLUMN()+2)","v":16564},{"$f":"INDIRECT(\"C\"&COLUMN()+2)","v":20156},{"$f":"INDIRECT(\"C\"&COLUMN()+2)","v":16546}]
[{"$f":"_xlfn.FORMULATEXT(B13)","v":"=INDIRECT(\"D\"&COLUMN()+2)"},{"$f":"INDIRECT(\"D\"&COLUMN()+2)","v":"New York"},{"$f":"INDIRECT(\"D\"&COLUMN()+2)","v":15630},{"$f":"INDIRECT(\"D\"&COLUMN()+2)","v":17865},{"$f":"INDIRECT(\"D\"&COLUMN()+2)","v":21354},{"$f":"INDIRECT(\"D\"&COLUMN()+2)","v":35654}]
["=INDIRECT(\"E\"&COLUMN()+2)",{"$f":"INDIRECT(\"E\"&COLUMN()+2)","v":"Boston"},{"$f":"INDIRECT(\"E\"&COLUMN()+2)","v":15984},{"$f":"INDIRECT(\"E\"&COLUMN()+2)","v":16420},{"$f":"INDIRECT(\"E\"&COLUMN()+2)","v":16546},{"$f":"INDIRECT(\"E\"&COLUMN()+2)","v":65413}]

{"sheet":"INDEX","index":6,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Combining INDEX and COLUMN Functions",null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,"April",16546,35654,65413]
[]
[null,{"$f":"INDEX($B$4:$E$8,COLUMN()-1,1)","v":"Sale'2023"},{"$f":"INDEX($B$4:$E$8,COLUMN()-1,1)","v":"January"},{"$f":"INDEX($B$4:$E$8,COLUMN()-1,1)","v":"Fabruary"},{"$f":"INDEX($B$4:$E$8,COLUMN()-1,1)","v":"March"},{"$f":"INDEX($B$4:$E$8,COLUMN()-1,1)","v":"April"}]
[{"$f":"_xlfn.FORMULATEXT(B11)","v":"=INDEX($B$4:$E$8,COLUMN()-1,2)"},{"$f":"INDEX($B$4:$E$8,COLUMN()-1,2)","v":"Texas"},10350,16564,20156,16546]
[{"$f":"_xlfn.FORMULATEXT(B12)","v":"=INDEX($B$4:$E$8,COLUMN()-1,3)"},{"$f":"INDEX($B$4:$E$8,COLUMN()-1,3)","v":"New York"},15630,17865,21354,35654]
["=INDEX($B$4:$E$8,COLUMN()-1,4)",{"$f":"INDEX($B$4:$E$8,COLUMN()-1,4)","v":"Boston"},15984,16420,16546,65413]

{"sheet":"XLOOKUP","index":7,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Joining TRANSPOSE with XLOOKUP Function",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,null,"April",16546,35654,65413]
[]
[null,"Search","Texas",null,null,null,null,null,null,"Search"]
[]
[null,{"$f":"TRANSPOSE((_xlfn.XLOOKUP(C10,B4:E4,B4:E8,\"No Result\",2)))","v":"Texas"},10350,16564,20156,16546]

{"sheet":"Find-Replace","index":8,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using Find and Replace Tool",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,null,"April",16546,35654,65413]
[]
[null,{"$f":"B4","v":"Sale'2023"},{"$f":"B5","v":"January"},{"$f":"B6","v":"Fabruary"},{"$f":"B7","v":"March"},{"$f":"B8","v":"April"}]
[null,{"$f":"C4","v":"Texas"},{"$f":"C5","v":10350},{"$f":"C6","v":16564},{"$f":"C7","v":20156},{"$f":"C8","v":16546}]
[null,{"$f":"D4","v":"New York"},{"$f":"D5","v":15630},{"$f":"D6","v":17865},{"$f":"D7","v":21354},{"$f":"D8","v":35654}]
[null,{"$f":"E4","v":"Boston"},{"$f":"E5","v":15984},{"$f":"E6","v":16420},{"$f":"E7","v":16546},{"$f":"E8","v":65413}]

{"sheet":"PowerQuery","index":9,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using Power-Query Tool",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,null,"April",16546,35654,65413]
[]
[null,"Sale'2023","January","Fabruary","March","April"]
[null,"Texas",10350,16564,20156,16546]
[null,"New York",15630,17865,21354,35654]
[null,"Boston",15984,16420,16546,65413]

{"sheet":"VBA","index":10,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using VBA Macro",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,null,"April",16546,35654,65413]
[]
[null,"Sale'2023","January","Fabruary","March","April"]
[null,"Texas",10350,16564,20156,16546]
[null,"New York",15630,17865,21354,35654]
[null,"Boston",15984,16420,16546,65413]

{"sheet":"Overview","index":11,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Overview of Transpose in Excel",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sale'2023","Texas","New York","Boston",null,null,null,null,"Sale'2023","Texas","New York","Boston"]
[null,"January",10350,15630,15984,null,null,null,null,"January",10350,15630,15984]
[null,"Fabruary",16564,17865,16420,null,null,null,null,"Fabruary",16564,17865,16420]
[null,"March",20156,21354,16546,null,null,null,null,"March",20156,21354,16546]
[null,"April",16546,35654,65413,null,null,null,null,"April",16546,35654,65413]
[]
[null,{"$f":"TRANSPOSE(B4:E8)","v":"Sale'2023"},"January","Fabruary","March","April"]
[null,"Texas",10350,16564,20156,16546]
[null,"New York",15630,17865,21354,35654]
[null,"Boston",15984,16420,16546,65413]