{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset 1","IF TRANSPOSE","Dataset 2","Formula","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":"Dataset 1","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Name & Salary data"]
[]
[null,"Name","Salary","Allowances","Total Salary"]
[null,"James",2000,250,{"$f":"SUM(C5,D5)","v":2250}]
[null,"Robert",1500,200,{"$f":"SUM(C6,D6)","v":1700}]
[null,"John",2500,300,2800]
[null,"Michael",3000,300,3300]
[null,"William",2000,250,2250]
[null,"David",2000,250,2250]
[null,"Richard",2000,250,2250]
[null,"Joseph",1500,200,1700]
[null,"Thomas",1700,250,1950]

{"sheet":"IF TRANSPOSE","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using IF and TRANSPOSE Function"]
[]
[null,"Name","Salary","Allowances","Total Salary",null,"Criteria"]
[null,"James",2000,250,{"$f":"SUM(C5,D5)","v":2250},null,2000]
[null,"Robert",1500,200,{"$f":"SUM(C6,D6)","v":1700}]
[null,"John",2500,300,2800]
[null,"Michael",3000,300,3300]
[null,"William",2000,250,2250]
[null,"David",2000,250,2250]
[null,"Richard",2000,250,2250]
[null,"Joseph",1500,200,1700]
[null,"Thomas",1700,250,1950]
[]
[null,{"$f":"IF(E5>G5,TRANSPOSE(B4:D13),\"\")","v":"Name"},"James","Robert","John","Michael","William","David","Richard","Joseph","Thomas"]
[null,"Salary",2000,1500,2500,3000,2000,2000,2000,1500,1700]
[null,"Allowances",250,200,300,300,250,250,250,200,250]

{"sheet":"Dataset 2","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset "]
[]
[null,"Order Date","Product","Quantity"]
[null,"2022-02-05","Bran",83]
[null,"2022-02-06","Oatmeal Raisin",124]
[null,"2022-02-07","Carrot",137]
[null,"2022-02-08","Arrowroot",146]
[null,"2022-02-09","Chocolate Chip",34]
[null,"2022-02-10","Carrot",20]
[null,"2022-02-11","Arrowroot",139]
[null,"2022-02-12","Chocolate Chip",211]
[null,"2022-02-13","Whole Wheat",20]
[null,"2022-02-14","Bran",42]
[null,"2022-02-15","Oatmeal Raisin",100]
[null,"2022-02-16","Carrot",38]
[null,"2022-02-17","Whole Wheat",25]

{"sheet":"Formula","index":3,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Formula to Transpose Cell in Another Column"]
[]
[null,"Order Date","Product","Quantity",null,"Product","Quantity","Quantity","Quantity"]
[null,"2022-02-05","Bran",83,null,{"$f":"INDEX($C$5:$C$17, MATCH(0, COUNTIF($F$4:$F4, $C$5:$C$17), 0))","v":"Bran"},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F5:F5,$D$5:$D$17)+IF($C$5:$C$17<>$F5, 1,0), 0)), 0)","v":83},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F5:G5,$D$5:$D$17)+IF($C$5:$C$17<>$F5, 1,0), 0)), 0)","v":42},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F5:H5,$D$5:$D$17)+IF($C$5:$C$17<>$F5, 1,0), 0)), 0)","v":0}]
[null,"2022-02-06","Oatmeal Raisin",124,null,{"$f":"INDEX($C$5:$C$17, MATCH(0, COUNTIF($F$4:$F5, $C$5:$C$17), 0))","v":"Oatmeal Raisin"},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F6:F6,$D$5:$D$17)+IF($C$5:$C$17<>$F6, 1,0), 0)), 0)","v":124},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F6:G6,$D$5:$D$17)+IF($C$5:$C$17<>$F6, 1,0), 0)), 0)","v":100},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F6:H6,$D$5:$D$17)+IF($C$5:$C$17<>$F6, 1,0), 0)), 0)","v":0}]
[null,"2022-02-07","Carrot",137,null,{"$f":"INDEX($C$5:$C$17, MATCH(0, COUNTIF($F$4:$F6, $C$5:$C$17), 0))","v":"Carrot"},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F7:F7,$D$5:$D$17)+IF($C$5:$C$17<>$F7, 1,0), 0)), 0)","v":137},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F7:G7,$D$5:$D$17)+IF($C$5:$C$17<>$F7, 1,0), 0)), 0)","v":20},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F7:H7,$D$5:$D$17)+IF($C$5:$C$17<>$F7, 1,0), 0)), 0)","v":38}]
[null,"2022-02-08","Arrowroot",146,null,{"$f":"INDEX($C$5:$C$17, MATCH(0, COUNTIF($F$4:$F7, $C$5:$C$17), 0))","v":"Arrowroot"},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F8:F8,$D$5:$D$17)+IF($C$5:$C$17<>$F8, 1,0), 0)), 0)","v":146},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F8:G8,$D$5:$D$17)+IF($C$5:$C$17<>$F8, 1,0), 0)), 0)","v":139},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F8:H8,$D$5:$D$17)+IF($C$5:$C$17<>$F8, 1,0), 0)), 0)","v":0}]
[null,"2022-02-09","Chocolate Chip",34,null,{"$f":"INDEX($C$5:$C$17, MATCH(0, COUNTIF($F$4:$F8, $C$5:$C$17), 0))","v":"Chocolate Chip"},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F9:F9,$D$5:$D$17)+IF($C$5:$C$17<>$F9, 1,0), 0)), 0)","v":34},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F9:G9,$D$5:$D$17)+IF($C$5:$C$17<>$F9, 1,0), 0)), 0)","v":211},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F9:H9,$D$5:$D$17)+IF($C$5:$C$17<>$F9, 1,0), 0)), 0)","v":0}]
[null,"2022-02-10","Carrot",20,null,{"$f":"INDEX($C$5:$C$17, MATCH(0, COUNTIF($F$4:$F9, $C$5:$C$17), 0))","v":"Whole Wheat"},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F10:F10,$D$5:$D$17)+IF($C$5:$C$17<>$F10, 1,0), 0)), 0)","v":20},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F10:G10,$D$5:$D$17)+IF($C$5:$C$17<>$F10, 1,0), 0)), 0)","v":25},{"$f":"IFERROR(INDEX($D$5:$D$17, MATCH(0, COUNTIF($F10:H10,$D$5:$D$17)+IF($C$5:$C$17<>$F10, 1,0), 0)), 0)","v":0}]
[null,"2022-02-11","Arrowroot",139]
[null,"2022-02-12","Chocolate Chip",211]
[null,"2022-02-13","Whole Wheat",20]
[null,"2022-02-14","Bran",42]
[null,"2022-02-15","Oatmeal Raisin",100]
[null,"2022-02-16","Carrot",38]
[null,"2022-02-17","Whole Wheat",25]

{"sheet":"VBA","index":4,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Macro Code"]
[]
[null,"Order Date","Product","Quantity",null,"Product","Quantity","Quantity","Quantity"]
[null,"2022-02-05","Bran",83,null,"Bran",83,42]
[null,"2022-02-06","Oatmeal Raisin",124,null,"Oatmeal Raisin",124,100]
[null,"2022-02-07","Carrot",137,null,"Carrot",137,20,38]
[null,"2022-02-08","Arrowroot",146,null,"Arrowroot",146,139]
[null,"2022-02-09","Chocolate Chip",34,null,"Chocolate Chip",34,211]
[null,"2022-02-10","Carrot",20,null,"Whole Wheat",20,25]
[null,"2022-02-11","Arrowroot",139]
[null,"2022-02-12","Chocolate Chip",211]
[null,"2022-02-13","Whole Wheat",20]
[null,"2022-02-14","Bran",42]
[null,"2022-02-15","Oatmeal Raisin",100]
[null,"2022-02-16","Carrot",38]
[null,"2022-02-17","Whole Wheat",25]