{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet3","Sheet2"],"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":"Sheet1","index":0,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Apply Formula with INDEX, MATCH, and COUNTIF Functions to Transpose Rows to Columns"]
[]
[null,"Product","Quanity",null,"Product","Quanity","Quanity","Quanity",null,null,null,null,null,null,null,null,null,null,null,"*=INDEX($B$5:$B$12, MATCH(0, COUNTIF($E$4:$E4, $B$5:$B$12), 0))"]
[null,"Sausage",100,null,{"$f":"INDEX($B$5:$B$12, MATCH(0, COUNTIF($E$4:$E4, $B$5:$B$12), 0))","v":"Sausage"},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E5:E5, $C$5:$C$12) + IF($B$5:$B$12<>$E5,1,0),0)),0)","v":100},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E5:F5, $C$5:$C$12) + IF($B$5:$B$12<>$E5,1,0),0)),0)","v":785},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E5:G5, $C$5:$C$12) + IF($B$5:$B$12<>$E5,1,0),0)),0)","v":362},null,null,null,null,null,null,null,"*=IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E5:E5, $C$5:$C$12) + IF($B$5:$B$12<>$E5,1,0),0)),0)"]
[null,"Cheese",561,null,{"$f":"INDEX($B$5:$B$12, MATCH(0, COUNTIF($E$4:$E5, $B$5:$B$12), 0))","v":"Cheese"},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E6:E6, $C$5:$C$12) + IF($B$5:$B$12<>$E6,1,0),0)),0)","v":561},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E6:F6, $C$5:$C$12) + IF($B$5:$B$12<>$E6,1,0),0)),0)","v":128},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E6:G6, $C$5:$C$12) + IF($B$5:$B$12<>$E6,1,0),0)),0)","v":0}]
[null,"Chicken",364,null,{"$f":"INDEX($B$5:$B$12, MATCH(0, COUNTIF($E$4:$E6, $B$5:$B$12), 0))","v":"Chicken"},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E7:E7, $C$5:$C$12) + IF($B$5:$B$12<>$E7,1,0),0)),0)","v":364},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E7:F7, $C$5:$C$12) + IF($B$5:$B$12<>$E7,1,0),0)),0)","v":124},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E7:G7, $C$5:$C$12) + IF($B$5:$B$12<>$E7,1,0),0)),0)","v":324}]
[null,"Sausage",785]
[null,"Chicken",124]
[null,"Chicken",324]
[null,"Sausage",362]
[null,"Cheese",128]

{"sheet":"Sheet3","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sample Data Set to Transpose Rows into Columns"]
[]
[null,"Product","Quanity",null,"Product","Quanity","Quanity","Quanity"]
[null,"Sausage",100,null,{"$f":"INDEX($B$5:$B$12, MATCH(0, COUNTIF($E$4:$E4, $B$5:$B$12), 0))","v":"Sausage"},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E5:E5, $C$5:$C$12) + IF($B$5:$B$12<>$E5,1,0),0)),0)","v":100},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E5:F5, $C$5:$C$12) + IF($B$5:$B$12<>$E5,1,0),0)),0)","v":785},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E5:G5, $C$5:$C$12) + IF($B$5:$B$12<>$E5,1,0),0)),0)","v":362}]
[null,"Cheese",561,null,{"$f":"INDEX($B$5:$B$12, MATCH(0, COUNTIF($E$4:$E5, $B$5:$B$12), 0))","v":"Cheese"},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E6:E6, $C$5:$C$12) + IF($B$5:$B$12<>$E6,1,0),0)),0)","v":561},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E6:F6, $C$5:$C$12) + IF($B$5:$B$12<>$E6,1,0),0)),0)","v":128},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E6:G6, $C$5:$C$12) + IF($B$5:$B$12<>$E6,1,0),0)),0)","v":0}]
[null,"Chicken",364,null,{"$f":"INDEX($B$5:$B$12, MATCH(0, COUNTIF($E$4:$E6, $B$5:$B$12), 0))","v":"Chicken"},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E7:E7, $C$5:$C$12) + IF($B$5:$B$12<>$E7,1,0),0)),0)","v":364},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E7:F7, $C$5:$C$12) + IF($B$5:$B$12<>$E7,1,0),0)),0)","v":124},{"$f":"IFERROR(INDEX($C$5:$C$12, MATCH(0, COUNTIF($E7:G7, $C$5:$C$12) + IF($B$5:$B$12<>$E7,1,0),0)),0)","v":324}]
[null,"Sausage",785]
[null,"Chicken",124]
[null,"Chicken",324]
[null,"Sausage",362]
[null,"Cheese",128]

{"sheet":"Sheet2","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Run a VBA Code to Transpose Rows to Columns"]
[]
[null,"Product","Quanity",null,"Product","Quanity","Quanity","Quanity"]
[null,"Sausage",100,null,"Sausage",100,785,362]
[null,"Cheese",561,null,"Cheese",561,128]
[null,"Chicken",364,null,"Chicken",364,124,324]
[null,"Sausage",785]
[null,"Chicken",124]
[null,"Chicken",324]
[null,"Sausage",362]
[null,"Cheese",128]