{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Paste Transpose Feature","Sort Feature","VBA","formula"],"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":"Paste Transpose Feature","index":0,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of Paste Transpose Feature",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Net Sales","Product","Salesman",null,null,null,null,null,null,null,"Net Sales","Product","Salesman"]
[null,2600,"Cable","Wilham",null,null,null,null,null,null,null,2600,"Cable","Wilham"]
[null,8750,"AC","Simon",null,null,null,null,null,null,null,8750,"AC","Simon"]
[null,7500,"TV","Frank",null,null,null,null,null,null,null,7500,"TV","Frank"]

{"sheet":"Sort Feature","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Sort Feature"]
[]
[null,"Net Sales","Product","Salesman"]
[null,2600,"Cable","Wilham"]
[null,8750,"AC","Simon"]
[null,7500,"TV","Frank"]

{"sheet":"VBA","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of VBA Method"]
[]
[null,"Net Sales","Product","Salesman"]
[null,2600,"Cable","Wilham"]
[null,8750,"AC","Simon"]
[null,7500,"TV","Frank"]

{"sheet":"formula","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Formula"]
[]
[null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable",2600]
[null,"Simon","AC",8750]
[null,"Frank","TV",7500]
[]
[null,{"$f":"INDEX($B4:$D4, COLUMNS(B4:$D4))","v":"Net Sales"},{"$f":"INDEX($B4:$D4, COLUMNS(C4:$D4))","v":"Product"},{"$f":"INDEX($B4:$D4, COLUMNS(D4:$D4))","v":"Salesman"}]
[null,{"$f":"INDEX($B5:$D5, COLUMNS(B5:$D5))","v":2600},{"$f":"INDEX($B5:$D5, COLUMNS(C5:$D5))","v":"Cable"},{"$f":"INDEX($B5:$D5, COLUMNS(D5:$D5))","v":"Wilham"}]
[null,{"$f":"INDEX($B6:$D6, COLUMNS(B6:$D6))","v":8750},{"$f":"INDEX($B6:$D6, COLUMNS(C6:$D6))","v":"AC"},{"$f":"INDEX($B6:$D6, COLUMNS(D6:$D6))","v":"Simon"}]
[null,{"$f":"INDEX($B7:$D7, COLUMNS(B7:$D7))","v":7500},{"$f":"INDEX($B7:$D7, COLUMNS(C7:$D7))","v":"TV"},{"$f":"INDEX($B7:$D7, COLUMNS(D7:$D7))","v":"Frank"}]