{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset-1","Sort Option-Vertically","SORTBY Function","INDEX Function","VBA Code-1","Sort Option-Horizontally","VBA Code-2","Dataset-2","Transpose Option"],"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":"Dataset-1","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Sales Reps"]
[]
[null,"Name","Sales"]
[null,"Sam",2435]
[null,"Adam",4025]
[null,"Anna",4767]
[null,"Harry",4533]
[null,"Tyler",1591]
[null,"Will",3660]
[null,"Smith",2092]
[null,"Julie",2914]
[null,"Gloria",2652]
[null,"Mary",1096]

{"sheet":"Sort Option-Vertically","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using Sort Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Sales","Helper Column",null,null,null,null,null,null,null,"Name","Sales","Helper Column"]
[null,"Mary",1096,10,null,null,null,null,null,null,null,"Sam",2435,1]
[null,"Gloria",2652,9,null,null,null,null,null,null,null,"Adam",4025,2]
[null,"Julie",2914,8,null,null,null,null,null,null,null,"Anna",4767,3]
[null,"Smith",2092,7,null,null,null,null,null,null,null,"Harry",4533,4]
[null,"Will",3660,6,null,null,null,null,null,null,null,"Tyler",1591,5]
[null,"Tyler",1591,5,null,null,null,null,null,null,null,"Will",3660,6]
[null,"Harry",4533,4,null,null,null,null,null,null,null,"Smith",2092,7]
[null,"Anna",4767,3,null,null,null,null,null,null,null,"Julie",2914,8]
[null,"Adam",4025,2,null,null,null,null,null,null,null,"Gloria",2652,9]
[null,"Sam",2435,1,null,null,null,null,null,null,null,"Mary",1096,10]

{"sheet":"SORTBY Function","index":2,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5],[1,11,1,12]]}
[]
[null,"Original Data",null,null,"Using SORTBY Function to Flip Data",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Sales",null,"Name","Sales",null,null,null,null,null,"Name","Sales"]
[null,"Sam",2435,null,{"$f":"_xlfn.SORTBY($B$5:$C$14,ROW(B5:B14),-1)","v":"Mary"},1096,null,null,null,null,null,"Sam",2435]
[null,"Adam",4025,null,"Gloria",2652,null,null,null,null,null,"Adam",4025]
[null,"Anna",4767,null,"Julie",2914,null,null,null,null,null,"Anna",4767]
[null,"Harry",4533,null,"Smith",2092,null,null,null,null,null,"Harry",4533]
[null,"Tyler",1591,null,"Will",3660,null,null,null,null,null,"Tyler",1591]
[null,"Will",3660,null,"Tyler",1591,null,null,null,null,null,"Will",3660]
[null,"Smith",2092,null,"Harry",4533,null,null,null,null,null,"Smith",2092]
[null,"Julie",2914,null,"Anna",4767,null,null,null,null,null,"Julie",2914]
[null,"Gloria",2652,null,"Adam",4025,null,null,null,null,null,"Gloria",2652]
[null,"Mary",1096,null,"Sam",2435,null,null,null,null,null,"Mary",1096]

{"sheet":"INDEX Function","index":3,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5],[1,11,1,12]]}
[]
[null,"Original Data",null,null,"Using INDEX Function to Flip Data",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Sales",null,"Name","Sales",null,null,null,null,null,"Name","Sales"]
[null,"Sam",2435,null,{"$f":"INDEX($B$5:$C$14,ROWS(B5:$B$14),COLUMNS($B$5:B5))","v":"Mary"},{"$f":"INDEX($B$5:$C$14,ROWS($B5:C$14),COLUMNS($B$5:C5))","v":1096},null,null,null,null,null,"Sam",2435]
[null,"Adam",4025,null,{"$f":"INDEX($B$5:$C$14,ROWS(B6:$B$14),COLUMNS($B$5:B6))","v":"Gloria"},{"$f":"INDEX($B$5:$C$14,ROWS($B6:C$14),COLUMNS($B$5:C6))","v":2652},null,null,null,null,null,"Adam",4025]
[null,"Anna",4767,null,{"$f":"INDEX($B$5:$C$14,ROWS(B7:$B$14),COLUMNS($B$5:B7))","v":"Julie"},{"$f":"INDEX($B$5:$C$14,ROWS($B7:C$14),COLUMNS($B$5:C7))","v":2914},null,null,null,null,null,"Anna",4767]
[null,"Harry",4533,null,{"$f":"INDEX($B$5:$C$14,ROWS(B8:$B$14),COLUMNS($B$5:B8))","v":"Smith"},{"$f":"INDEX($B$5:$C$14,ROWS($B8:C$14),COLUMNS($B$5:C8))","v":2092},null,null,null,null,null,"Harry",4533]
[null,"Tyler",1591,null,{"$f":"INDEX($B$5:$C$14,ROWS(B9:$B$14),COLUMNS($B$5:B9))","v":"Will"},{"$f":"INDEX($B$5:$C$14,ROWS($B9:C$14),COLUMNS($B$5:C9))","v":3660},null,null,null,null,null,"Tyler",1591]
[null,"Will",3660,null,{"$f":"INDEX($B$5:$C$14,ROWS(B10:$B$14),COLUMNS($B$5:B10))","v":"Tyler"},{"$f":"INDEX($B$5:$C$14,ROWS($B10:C$14),COLUMNS($B$5:C10))","v":1591},null,null,null,null,null,"Will",3660]
[null,"Smith",2092,null,{"$f":"INDEX($B$5:$C$14,ROWS(B11:$B$14),COLUMNS($B$5:B11))","v":"Harry"},{"$f":"INDEX($B$5:$C$14,ROWS($B11:C$14),COLUMNS($B$5:C11))","v":4533},null,null,null,null,null,"Smith",2092]
[null,"Julie",2914,null,{"$f":"INDEX($B$5:$C$14,ROWS(B12:$B$14),COLUMNS($B$5:B12))","v":"Anna"},{"$f":"INDEX($B$5:$C$14,ROWS($B12:C$14),COLUMNS($B$5:C12))","v":4767},null,null,null,null,null,"Julie",2914]
[null,"Gloria",2652,null,{"$f":"INDEX($B$5:$C$14,ROWS(B13:$B$14),COLUMNS($B$5:B13))","v":"Adam"},{"$f":"INDEX($B$5:$C$14,ROWS($B13:C$14),COLUMNS($B$5:C13))","v":4025},null,null,null,null,null,"Gloria",2652]
[null,"Mary",1096,null,{"$f":"INDEX($B$5:$C$14,ROWS(B14:$B$14),COLUMNS($B$5:B14))","v":"Sam"},{"$f":"INDEX($B$5:$C$14,ROWS($B14:C$14),COLUMNS($B$5:C14))","v":2435},null,null,null,null,null,"Mary",1096]

{"sheet":"VBA Code-1","index":4,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Sales",null,null,null,null,null,null,null,null,"Name","Sales"]
[null,"Mary",1096,null,null,null,null,null,null,null,null,"Sam",2435]
[null,"Gloria",2652,null,null,null,null,null,null,null,null,"Adam",4025]
[null,"Julie",2914,null,null,null,null,null,null,null,null,"Anna",4767]
[null,"Smith",2092,null,null,null,null,null,null,null,null,"Harry",4533]
[null,"Will",3660,null,null,null,null,null,null,null,null,"Tyler",1591]
[null,"Tyler",1591,null,null,null,null,null,null,null,null,"Will",3660]
[null,"Harry",4533,null,null,null,null,null,null,null,null,"Smith",2092]
[null,"Anna",4767,null,null,null,null,null,null,null,null,"Julie",2914]
[null,"Adam",4025,null,null,null,null,null,null,null,null,"Gloria",2652]
[null,"Sam",2435,null,null,null,null,null,null,null,null,"Mary",1096]

{"sheet":"Sort Option-Horizontally","index":5,"n_rows":6,"n_cols":26,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,11],[1,15,1,25]]}
[]
[null,"Using Sort Option",null,null,null,null,null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Mary","Gloria","Julie","Smith","Will","Tyler","Harry","Anna","Adam","Sam",null,null,null,"Name","Sam","Adam","Anna","Harry","Tyler","Will","Smith","Julie","Gloria","Mary"]
[null,"Sales",1096,2652,2914,2092,3660,1591,4533,4767,4025,2435,null,null,null,"Sales",2435,4025,4767,4533,1591,3660,2092,2914,2652,1096]
[null,"Helper Column",10,9,8,7,6,5,4,3,2,1,null,null,null,"Helper Column",1,2,3,4,5,6,7,8,9,10]

{"sheet":"VBA Code-2","index":6,"n_rows":5,"n_cols":28,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,11],[1,17,1,27]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Mary","Gloria","Julie","Smith","Will","Tyler","Harry","Anna","Adam","Sam",null,null,null,null,null,"Name","Sam","Adam","Anna","Harry","Tyler","Will","Smith","Julie","Gloria","Mary"]
[null,"Sales",1096,2652,2914,2092,3660,1591,4533,4767,4025,2435,null,null,null,null,null,"Sales",2435,4025,4767,4533,1591,3660,2092,2914,2652,1096]

{"sheet":"Dataset-2","index":7,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Marks Distribution of Students"]
[]
[null,null,"Physics","Chemistry","Biology","Maths"]
[null,"Zoe",82,62,51,74]
[null,"Ana",45,85,66,82]
[null,"Michell",86,88,80,50]
[null,"Patrick",49,60,76,59]
[null,"John",92,73,84,52]
[null,"Tom",57,76,93,62]
[null,"Judy",77,82,97,89]

{"sheet":"Transpose Option","index":8,"n_rows":11,"n_cols":19,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,8],[1,14,1,18]]}
[]
[null,"Using Transpose Option",null,null,null,null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,null,"Zoe","Ana","Michell","Patrick","John","Tom","Judy",null,null,null,null,null,null,"Physics","Chemistry","Biology","Maths"]
[null,"Physics",82,45,86,49,92,57,77,null,null,null,null,null,"Zoe",82,62,51,74]
[null,"Chemistry",62,85,88,60,73,76,82,null,null,null,null,null,"Ana",45,85,66,82]
[null,"Biology",51,66,80,76,84,93,97,null,null,null,null,null,"Michell",86,88,80,50]
[null,"Maths",74,82,50,59,52,62,89,null,null,null,null,null,"Patrick",49,60,76,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"John",92,73,84,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tom",57,76,93,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Judy",77,82,97,89]