{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sort & Transpose Command","INDEX & TRANSPOSE","SORTBY & TRANSPOSE","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sort & Transpose Command","index":0,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,7,1,8],[1,1,1,2]]}
[]
[null,"Use of Sort & Transpose Commands",null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Price",null,null,null,null,"Product Name","Price"]
[null,"Face Wash",180,null,null,null,null,"Shampoo",320]
[null,"Lipstick",210,null,null,null,null,"Conditioner",350]
[null,"Conditioner",350,null,null,null,null,"Lipstick",210]
[null,"Shampoo",320,null,null,null,null,"Face Wash",180]
[]
[null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320]

{"sheet":"INDEX & TRANSPOSE","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,9,1,10],[1,1,1,5]]}
[]
[null,"Use of INDEX & TRANSPOSE Functions",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Price",null,"Product Name","Price",null,null,null,"Product Name","Price"]
[null,"Shampoo",320,null,{"$f":"INDEX($B$5:$C$8,ROWS(B5:$B$8),COLUMNS($B$5:B5))","v":"Face Wash"},{"$f":"INDEX($B$5:$C$8,ROWS($B5:C$8),COLUMNS($B$5:C5))","v":180},null,null,null,"Shampoo",320]
[null,"Conditioner",350,null,{"$f":"INDEX($B$5:$C$8,ROWS(B6:$B$8),COLUMNS($B$5:B6))","v":"Lipstick"},{"$f":"INDEX($B$5:$C$8,ROWS($B6:C$8),COLUMNS($B$5:C6))","v":210},null,null,null,"Conditioner",350]
[null,"Lipstick",210,null,{"$f":"INDEX($B$5:$C$8,ROWS(B7:$B$8),COLUMNS($B$5:B7))","v":"Conditioner"},{"$f":"INDEX($B$5:$C$8,ROWS($B7:C$8),COLUMNS($B$5:C7))","v":350},null,null,null,"Lipstick",210]
[null,"Face Wash",180,null,{"$f":"INDEX($B$5:$C$8,ROWS(B8:$B$8),COLUMNS($B$5:B8))","v":"Shampoo"},{"$f":"INDEX($B$5:$C$8,ROWS($B8:C$8),COLUMNS($B$5:C8))","v":320},null,null,null,"Face Wash",180]
[]
[null,{"$f":"TRANSPOSE(E4:F8)","v":"Product Name"},"Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320]

{"sheet":"SORTBY & TRANSPOSE","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,9,1,10],[1,1,1,5]]}
[]
[null,"Use of SORTBY & TRANSPOSE Functions",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Price",null,"Product Name","Price",null,null,null,"Product Name","Price"]
[null,"Shampoo",320,null,{"$f":"_xlfn.SORTBY($B$5:$C$8,ROW(B5:B8),-1)","v":"Face Wash"},180,null,null,null,"Shampoo",320]
[null,"Conditioner",350,null,"Lipstick",210,null,null,null,"Conditioner",350]
[null,"Lipstick",210,null,"Conditioner",350,null,null,null,"Lipstick",210]
[null,"Face Wash",180,null,"Shampoo",320,null,null,null,"Face Wash",180]
[]
[null,{"$f":"TRANSPOSE(E4:F8)","v":"Product Name"},"Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320]

{"sheet":"VBA","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Price",null,null,null,null,null,"Product Name","Price"]
[null,"Face Wash",180,null,null,null,null,null,"Shampoo",320]
[null,"Lipstick",210,null,null,null,null,null,"Conditioner",350]
[null,"Conditioner",350,null,null,null,null,null,"Lipstick",210]
[null,"Shampoo",320,null,null,null,null,null,"Face Wash",180]
[]
[null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320]