{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Using ISEVEN function ","Using IF function","Go to special","Using VBA","Using isodd function","INDEX,ROW,COLUMN"],"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","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Moving Every Other Row to Column"]
[]
[null,"Product Id","Profit"]
[null,"A-051456",1525,{"$f":"IF(ISEVEN(ROW(C5)),C5,\"\")","v":""}]
[null,"F-652154",100]
[null,"F-652154",100]
[null,"A-031021",480]
[null,"C-001458",8390]
[null,"C-012145",500]
[null,"C-001458",8390]
[null,"A-032145",1235]
[null,"C-001458",8390]
[null,"D-562314",1270]
[null,"F-652154",100]
[null,"C-012145",500]

{"sheet":"Using ISEVEN function ","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,3,3,4],[1,1,1,4]]}
[]
[null,"Combining IF, ISEVEN and ROW Functions"]
[]
[null,"Product Id","Profit","Alternate Value"]
[null,"A-051456",1525,{"$f":"IF(ISEVEN(ROW(C5)),C5,\"\")","v":""},{"$f":"IF(ISEVEN(ROW(C5)),\"\",C5)","v":1525}]
[null,"F-652154",100,100,{"$f":"IF(ISEVEN(ROW(C6)),\"\",C6)","v":""}]
[null,"F-652154",100,"",100]
[null,"A-031021",480,480,""]
[null,"C-001458",8390,"",8390]
[null,"C-012145",500,500,""]
[null,"C-001458",8390,"",8390]
[null,"A-032145",1235,1235,""]
[null,"C-001458",8390,"",8390]
[null,"D-562314",1270,1270,""]
[null,"F-652154",100,"",100]
[null,"C-012145",500,500,""]

{"sheet":"Using IF function","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,4,3,5]]}
[]
[null,"Applying IF Function"]
[]
[null,"Product Id","Profit","Helper Column","Alternate Value"]
[null,"A-051456",1525,"x",{"$f":"IF(D5=\"x\",C5,\"\")","v":1525},{"$f":"IF(D5=\"x\",\"\",C5)","v":""}]
[null,"F-652154",100,null,{"$f":"IF(D6=\"x\",C6,\"\")","v":""},{"$f":"IF(D6=\"x\",\"\",C6)","v":100}]
[null,"F-652154",100,"x",100,""]
[null,"A-031021",480,null,"",480]
[null,"C-001458",8390,"x",8390,""]
[null,"C-012145",500,null,"",500]
[null,"C-001458",8390,"x",8390,""]
[null,"A-032145",1235,null,"",1235]
[null,"C-001458",8390,"x",8390,""]
[null,"D-562314",1270,null,"",1270]
[null,"F-652154",100,"x",100,""]
[null,"C-012145",500,null,"",500]

{"sheet":"Go to special","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilizing Go To Special Feature"]
[]
[null,"Helper Column","Product Id","Profit"]
[null,"x","A-051456",1525]
[null,"x","F-652154",100]
[null,"x","C-001458",8390]
[null,"x","C-001458",8390]
[null,"x","C-001458",8390]
[null,"x","F-652154",100]
[null,"x","D-562314",1270]
[]
[null,"Helper Column","Product Id","Profit"]
[null,"x","F-652154",100]
[null,"x","A-031021",480]
[null,"x","C-012145",500]
[null,"x","A-032145",1235]
[null,"x","D-562314",1270]
[null,"x","C-012145",500]

{"sheet":"Using VBA","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,3,3,4],[1,1,1,4]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Product Id","Profit","Alternate Value"]
[null,"A-051456",1525]
[null,"F-652154",100]
[null,"F-652154",150]
[null,"A-031021",480]
[null,"C-001458",8390]
[null,"C-012145",500]
[null,"C-001458",8390]
[null,"A-032145",1235]
[null,"C-001458",8390]
[null,"D-562314",1270]
[null,"F-652154",100]
[null,"C-012145",500]

{"sheet":"Using isodd function","index":5,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,3,3,4],[1,1,1,4]]}
[]
[null,"Using IF, ISODD and ROW Functions"]
[]
[null,"Product Id","Profit","Alternate Value"]
[null,"A-051456",1525,{"$f":"IF(ISODD(ROW(C5)),C5,\"\")","v":1525},{"$f":"IF(ISODD(ROW(C5)),\"\",C5)","v":""}]
[null,"F-652154",100,{"$f":"IF(ISODD(ROW(C6)),C6,\"\")","v":""},{"$f":"IF(ISODD(ROW(C6)),\"\",C6)","v":100}]
[null,"F-652154",100,100,""]
[null,"A-031021",480,"",480]
[null,"C-001458",8390,8390,""]
[null,"C-012145",500,"",500]
[null,"C-001458",8390,8390,""]
[null,"A-032145",1235,"",1235]
[null,"C-001458",8390,8390,""]
[null,"D-562314",1270,"",1270]
[null,"F-652154",100,100,""]
[null,"C-012145",500,"",500]

{"sheet":"INDEX,ROW,COLUMN","index":6,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,3,3,4],[1,1,1,4]]}
[]
[null,"Applying INDEX, ROW and COLUMN Functions"]
[]
[null,"Product Id","Profit","Alternate Value"]
[null,"A-051456",1525,{"$f":"INDEX($C:$C,ROW(C2)*2-2+COLUMN(C3))","v":1525},{"$f":"INDEX($C:$C,ROW(D2)*2-2+COLUMN(D3))","v":100}]
[null,"F-652154",100,{"$f":"INDEX($C:$C,ROW(C3)*2-1.5+COLUMN(C4))","v":100},{"$f":"INDEX($C:$C,ROW(D3)*2-1.5+COLUMN(D4))","v":480}]
[null,"F-652154",100,{"$f":"INDEX($C:$C,ROW(C4)*2-1.5+COLUMN(C5))","v":8390},{"$f":"INDEX($C:$C,ROW(D4)*2-1.5+COLUMN(D5))","v":500}]
[null,"A-031021",480,{"$f":"INDEX($C:$C,ROW(C5)*2-1.5+COLUMN(C6))","v":8390},{"$f":"INDEX($C:$C,ROW(D5)*2-1.5+COLUMN(D6))","v":1235}]
[null,"C-001458",8390,{"$f":"INDEX($C:$C,ROW(C6)*2-1.5+COLUMN(C7))","v":8390},{"$f":"INDEX($C:$C,ROW(D6)*2-1.5+COLUMN(D7))","v":1270}]
[null,"C-012145",500,{"$f":"INDEX($C:$C,ROW(C7)*2-1.5+COLUMN(C8))","v":100},{"$f":"INDEX($C:$C,ROW(D7)*2-1.5+COLUMN(D8))","v":500}]
[null,"C-001458",8390]
[null,"A-032145",1235]
[null,"C-001458",8390]
[null,"D-562314",1270]
[null,"F-652154",100]
[null,"C-012145",500]