{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Transpose","TRANSPOSE Function","INDIRECT&ADDRESS","INDEX","INDEX-MATCH","VLOOKUP","Power Query","Table5","VBA","OFFSET","Practice"],"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":"Dataset","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Sales Records of \"XYZ\" Company"]
[]
[null,"Month","Orange","Apple","Cherry"]
[null,"January",2643,3530,4465]
[null,"February",2602,3486,4961]
[null,"March",2825,3430,4432]
[null,"April",2506,3063,4070]
[null,"May",2020,3546,4337]

{"sheet":"Transpose","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Transpose Option"]
[]
[null,"Month","Orange","Apple","Cherry"]
[null,"January",2643,3530,4465]
[null,"February",2602,3486,4961]
[null,"March",2825,3430,4432]
[null,"April",2506,3063,4070]
[null,"May",2020,3546,4337]
[]
[null,"Month","January","February","March","April","May"]
[null,"Orange",2643,2602,2825,2506,2020]
[null,"Apple",3530,3486,3430,3063,3546]
[null,"Cherry",4465,4961,4432,4070,4337]

{"sheet":"TRANSPOSE Function","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using TRANSPOSE Function"]
[]
[null,"Month","Orange","Apple","Cherry"]
[null,"January",2643,3530,4465]
[null,"February",2602,3486,4961]
[null,"March",2825,3430,4432]
[null,"April",2506,3063,4070]
[null,"May",2020,3546,4337]
[]
[null,{"$f":"TRANSPOSE(B3:E8)","v":"Month"},"January","February","March","April","May"]
[null,"Orange",2643,2602,2825,2506,2020]
[null,"Apple",3530,3486,3430,3063,3546]
[null,"Cherry",4465,4961,4432,4070,4337]

{"sheet":"INDIRECT&ADDRESS","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Using INDIRECT & ADDRESS Functions"]
[]
[null,"Month","Orange","Apple","Cherry"]
[null,"January",2643,3530,4465]
[null,"February",2602,3486,4961]
[null,"March",2825,3430,4432]
[null,"April",2506,3063,4070]
[null,"May",2020,3546,4337]
[]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B3) - COLUMN($B$3) + ROW($B$3), ROW(B3) - ROW($B$3) + COLUMN($B$3)))","v":"Month"},{"$f":"INDIRECT(ADDRESS(COLUMN(C3) - COLUMN($B$3) + ROW($B$3), ROW(C3) - ROW($B$3) + COLUMN($B$3)))","v":"January"},{"$f":"INDIRECT(ADDRESS(COLUMN(D3) - COLUMN($B$3) + ROW($B$3), ROW(D3) - ROW($B$3) + COLUMN($B$3)))","v":"February"},{"$f":"INDIRECT(ADDRESS(COLUMN(E3) - COLUMN($B$3) + ROW($B$3), ROW(E3) - ROW($B$3) + COLUMN($B$3)))","v":"March"},{"$f":"INDIRECT(ADDRESS(COLUMN(F3) - COLUMN($B$3) + ROW($B$3), ROW(F3) - ROW($B$3) + COLUMN($B$3)))","v":"April"},{"$f":"INDIRECT(ADDRESS(COLUMN(G3) - COLUMN($B$3) + ROW($B$3), ROW(G3) - ROW($B$3) + COLUMN($B$3)))","v":"May"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B4) - COLUMN($B$3) + ROW($B$3), ROW(B4) - ROW($B$3) + COLUMN($B$3)))","v":"Orange"},{"$f":"INDIRECT(ADDRESS(COLUMN(C4) - COLUMN($B$3) + ROW($B$3), ROW(C4) - ROW($B$3) + COLUMN($B$3)))","v":2643},{"$f":"INDIRECT(ADDRESS(COLUMN(D4) - COLUMN($B$3) + ROW($B$3), ROW(D4) - ROW($B$3) + COLUMN($B$3)))","v":2602},{"$f":"INDIRECT(ADDRESS(COLUMN(E4) - COLUMN($B$3) + ROW($B$3), ROW(E4) - ROW($B$3) + COLUMN($B$3)))","v":2825},{"$f":"INDIRECT(ADDRESS(COLUMN(F4) - COLUMN($B$3) + ROW($B$3), ROW(F4) - ROW($B$3) + COLUMN($B$3)))","v":2506},{"$f":"INDIRECT(ADDRESS(COLUMN(G4) - COLUMN($B$3) + ROW($B$3), ROW(G4) - ROW($B$3) + COLUMN($B$3)))","v":2020}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B5) - COLUMN($B$3) + ROW($B$3), ROW(B5) - ROW($B$3) + COLUMN($B$3)))","v":"Apple"},{"$f":"INDIRECT(ADDRESS(COLUMN(C5) - COLUMN($B$3) + ROW($B$3), ROW(C5) - ROW($B$3) + COLUMN($B$3)))","v":3530},{"$f":"INDIRECT(ADDRESS(COLUMN(D5) - COLUMN($B$3) + ROW($B$3), ROW(D5) - ROW($B$3) + COLUMN($B$3)))","v":3486},{"$f":"INDIRECT(ADDRESS(COLUMN(E5) - COLUMN($B$3) + ROW($B$3), ROW(E5) - ROW($B$3) + COLUMN($B$3)))","v":3430},{"$f":"INDIRECT(ADDRESS(COLUMN(F5) - COLUMN($B$3) + ROW($B$3), ROW(F5) - ROW($B$3) + COLUMN($B$3)))","v":3063},{"$f":"INDIRECT(ADDRESS(COLUMN(G5) - COLUMN($B$3) + ROW($B$3), ROW(G5) - ROW($B$3) + COLUMN($B$3)))","v":3546}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B6) - COLUMN($B$3) + ROW($B$3), ROW(B6) - ROW($B$3) + COLUMN($B$3)))","v":"Cherry"},{"$f":"INDIRECT(ADDRESS(COLUMN(C6) - COLUMN($B$3) + ROW($B$3), ROW(C6) - ROW($B$3) + COLUMN($B$3)))","v":4465},{"$f":"INDIRECT(ADDRESS(COLUMN(D6) - COLUMN($B$3) + ROW($B$3), ROW(D6) - ROW($B$3) + COLUMN($B$3)))","v":4961},{"$f":"INDIRECT(ADDRESS(COLUMN(E6) - COLUMN($B$3) + ROW($B$3), ROW(E6) - ROW($B$3) + COLUMN($B$3)))","v":4432},{"$f":"INDIRECT(ADDRESS(COLUMN(F6) - COLUMN($B$3) + ROW($B$3), ROW(F6) - ROW($B$3) + COLUMN($B$3)))","v":4070},{"$f":"INDIRECT(ADDRESS(COLUMN(G6) - COLUMN($B$3) + ROW($B$3), ROW(G6) - ROW($B$3) + COLUMN($B$3)))","v":4337}]

{"sheet":"INDEX","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Using INDEX Function"]
[]
[null,"Month","Orange","Apple","Cherry"]
[null,"January",2643,3530,4465]
[null,"February",2602,3486,4961]
[null,"March",2825,3430,4432]
[null,"April",2506,3063,4070]
[null,"May",2020,3546,4337]
[]
[null,{"$f":"INDEX($B$3:$E$8,COLUMN(A1),ROW(A1))","v":"Month"},{"$f":"INDEX($B$3:$E$8,COLUMN(B1),ROW(B1))","v":"January"},{"$f":"INDEX($B$3:$E$8,COLUMN(C1),ROW(C1))","v":"February"},{"$f":"INDEX($B$3:$E$8,COLUMN(D1),ROW(D1))","v":"March"},{"$f":"INDEX($B$3:$E$8,COLUMN(E1),ROW(E1))","v":"April"},{"$f":"INDEX($B$3:$E$8,COLUMN(F1),ROW(F1))","v":"May"}]
[null,{"$f":"INDEX($B$3:$E$8,COLUMN(A2),ROW(A2))","v":"Orange"},{"$f":"INDEX($B$3:$E$8,COLUMN(B2),ROW(B2))","v":2643},{"$f":"INDEX($B$3:$E$8,COLUMN(C2),ROW(C2))","v":2602},{"$f":"INDEX($B$3:$E$8,COLUMN(D2),ROW(D2))","v":2825},{"$f":"INDEX($B$3:$E$8,COLUMN(E2),ROW(E2))","v":2506},{"$f":"INDEX($B$3:$E$8,COLUMN(F2),ROW(F2))","v":2020}]
[null,{"$f":"INDEX($B$3:$E$8,COLUMN(A3),ROW(A3))","v":"Apple"},{"$f":"INDEX($B$3:$E$8,COLUMN(B3),ROW(B3))","v":3530},{"$f":"INDEX($B$3:$E$8,COLUMN(C3),ROW(C3))","v":3486},{"$f":"INDEX($B$3:$E$8,COLUMN(D3),ROW(D3))","v":3430},{"$f":"INDEX($B$3:$E$8,COLUMN(E3),ROW(E3))","v":3063},{"$f":"INDEX($B$3:$E$8,COLUMN(F3),ROW(F3))","v":3546}]
[null,{"$f":"INDEX($B$3:$E$8,COLUMN(A4),ROW(A4))","v":"Cherry"},{"$f":"INDEX($B$3:$E$8,COLUMN(B4),ROW(B4))","v":4465},{"$f":"INDEX($B$3:$E$8,COLUMN(C4),ROW(C4))","v":4961},{"$f":"INDEX($B$3:$E$8,COLUMN(D4),ROW(D4))","v":4432},{"$f":"INDEX($B$3:$E$8,COLUMN(E4),ROW(E4))","v":4070},{"$f":"INDEX($B$3:$E$8,COLUMN(F4),ROW(F4))","v":4337}]

{"sheet":"INDEX-MATCH","index":5,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Using INDEX, MATCH Functions"]
[]
[null,"Month","Orange","Apple","Cherry"]
[null,"January",2643,3530,4465]
[null,"February",2602,3486,4961]
[null,"March",2825,3430,4432]
[null,"April",2506,3063,4070]
[null,"May",2020,3546,4337]
[]
[null,"Month","January","February","March","April","May"]
[null,{"$f":"INDEX($C$3:$C$8,MATCH(B$10,$B$3:$B$8,0))","v":"Orange"},{"$f":"INDEX($C$3:$C$8,MATCH(C$10,$B$3:$B$8,0))","v":2643},2602,2825,2506,2020]
[null,{"$f":"INDEX($D$3:$D$8,MATCH(B$10,$B$3:$B$8,0))","v":"Apple"},{"$f":"INDEX($D$3:$D$8,MATCH(C$10,$B$3:$B$8,0))","v":3530},3486,3430,3063,3546]
[null,{"$f":"INDEX($E$3:$E$8,MATCH(B$10,$B$3:$B$8,0))","v":"Cherry"},{"$f":"INDEX($E$3:$E$8,MATCH(C$10,$B$3:$B$8,0))","v":4465},4961,4432,4070,4337]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VLOOKUP","index":6,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Using VLOOKUP Function"]
[]
[null,"Month","Orange","Apple","Cherry"]
[null,"January",2643,3530,4465]
[null,"February",2602,3486,4961]
[null,"March",2825,3430,4432]
[null,"April",2506,3063,4070]
[null,"May",2020,3546,4337]
[]
[null,"Month","January","February","March","April","May"]
[null,{"$f":"VLOOKUP(B$10,$B$3:$E$8,2,FALSE)","v":"Orange"},{"$f":"VLOOKUP(C$10,$B$3:$E$8,2,FALSE)","v":2643},2602,2825,2506,2020]
[null,{"$f":"VLOOKUP(B$10,$B$3:$E$8,3,FALSE)","v":"Apple"},{"$f":"VLOOKUP(C$10,$B$3:$E$8,3,FALSE)","v":3530},3486,3430,3063,3546]
[null,{"$f":"VLOOKUP(B$10,$B$3:$E$8,4,FALSE)","v":"Cherry"},{"$f":"VLOOKUP(C$10,$B$3:$E$8,4,FALSE)","v":4465},4961,4432,4070,4337]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Power Query","index":7,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Power Query"]
[]
[null,"Column 1","Column 2","Column 3","Column 4"]
[null,"Month","Orange","Apple","Cherry"]
[null,"January",2643,3530,4465]
[null,"February",2602,3486,4961]
[null,"March",2825,3430,4432]
[null,"April",2506,3063,4070]
[null,"May",2020,3546,4337]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"Table5","index":8,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Month","January","February","March","April","May"]
["Orange",2643,2602,2825,2506,2020]
["Apple",3530,3486,3430,3063,3546]
["Cherry",4465,4961,4432,4070,4337]

{"sheet":"VBA","index":9,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Using VBA Code"]
[]
[null,"Month","Orange","Apple","Cherry"]
[null,"January",2643,3530,4465]
[null,"February",2602,3486,4961]
[null,"March",2825,3430,4432]
[null,"April",2506,3063,4070]
[null,"May",2020,3546,4337]
[]
[null,"Month","January","February","March","April","May"]
[null,"Orange",2643,2602,2825,2506,2020]
[null,"Apple",3530,3486,3430,3063,3546]
[null,"Cherry",4465,4961,4432,4070,4337]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"OFFSET","index":10,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using OFFSET Function"]
[]
[null,"List",null,"Name","Subject","Marks"]
[null,"Joseph",null,{"$f":"OFFSET($B$4,COLUMN()-4+(ROW()-4)*3,0,1,1)","v":"Joseph"},{"$f":"OFFSET($B$4,COLUMN()-4+(ROW()-4)*3,0,1,1)","v":"Math"},97]
[null,"Math",null,{"$f":"OFFSET($B$4,COLUMN()-4+(ROW()-4)*3,0,1,1)","v":"Michael"},"Physics",78]
[null,97,null,"Sara","Chemistry",95]
[null,"Michael"]
[null,"Physics"]
[null,78]
[null,"Sara"]
[null,"Chemistry"]
[null,95]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Practice","index":11,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Practice"]
[]
[null,"Month","Orange","Apple","Cherry",null,"List"]
[null,"January",2643,3530,4465,null,"Joseph"]
[null,"February",2602,3486,4961,null,"Math"]
[null,"March",2825,3430,4432,null,97]
[null,"April",2506,3063,4070,null,"Michael"]
[null,"May",2020,3546,4337,null,"Physics"]
[null,null,null,null,null,null,78]
[null,null,null,null,null,null,"Sara"]
[null,null,null,null,null,null,"Chemistry"]
[null,null,null,null,null,null,95]