{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Paste Special","TRANSPOSE","Find & Replace","INDIRECT & ADDRESS","VBA","Power Query","Table2"],"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":"Paste Special","index":0,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Use of Paste Special Feature",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo",null,null,null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320,null,null,null,"Price",180,210,350,320]
[]
[null,"Product Name","Price"]
[null,"Face Wash",180]
[null,"Lipstick",210]
[null,"Conditioner",350]
[null,"Shampoo",320]

{"sheet":"TRANSPOSE","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Use of TRANSPOSE Function",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo",null,null,null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320,null,null,null,"Price",180,210,350,320]
[]
[null,{"$f":"TRANSPOSE(B4:F5)","v":"Product Name"},"Price"]
[null,"Face Wash",180]
[null,"Lipstick",210]
[null,"Conditioner",350]
[null,"Shampoo",320]

{"sheet":"Find & Replace","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Use of Find & Replace Feature",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo",null,null,null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320,null,null,null,"Price",180,210,350,320]
[]
[null,{"$f":"$B$4","v":"Product Name"},{"$f":"$B$5","v":"Price"}]
[null,{"$f":"$C$4","v":"Face Wash"},{"$f":"$C$5","v":180}]
[null,{"$f":"$D$4","v":"Lipstick"},{"$f":"$D$5","v":210}]
[null,{"$f":"$E$4","v":"Conditioner"},{"$f":"$E$5","v":350}]
[null,{"$f":"$F$4","v":"Shampoo"},{"$f":"$F$5","v":320}]

{"sheet":"INDIRECT & ADDRESS","index":3,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Combination of INDIRECT & ADDRESS Functions",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo",null,null,null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320,null,null,null,"Price",180,210,350,320]
[]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B4)-COLUMN($B$4)\n+ROW($B$4), ROW(B4)-ROW($B$4)+COLUMN($B$4)))","v":"Product Name"},{"$f":"INDIRECT(ADDRESS(COLUMN(C4)-COLUMN($B$4)\n+ROW($B$4), ROW(C4)-ROW($B$4)+COLUMN($B$4)))","v":"Price"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B5)-COLUMN($B$4)\n+ROW($B$4), ROW(B5)-ROW($B$4)+COLUMN($B$4)))","v":"Face Wash"},{"$f":"INDIRECT(ADDRESS(COLUMN(C5)-COLUMN($B$4)\n+ROW($B$4), ROW(C5)-ROW($B$4)+COLUMN($B$4)))","v":180}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B6)-COLUMN($B$4)\n+ROW($B$4), ROW(B6)-ROW($B$4)+COLUMN($B$4)))","v":"Lipstick"},{"$f":"INDIRECT(ADDRESS(COLUMN(C6)-COLUMN($B$4)\n+ROW($B$4), ROW(C6)-ROW($B$4)+COLUMN($B$4)))","v":210}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B7)-COLUMN($B$4)\n+ROW($B$4), ROW(B7)-ROW($B$4)+COLUMN($B$4)))","v":"Conditioner"},{"$f":"INDIRECT(ADDRESS(COLUMN(C7)-COLUMN($B$4)\n+ROW($B$4), ROW(C7)-ROW($B$4)+COLUMN($B$4)))","v":350}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B8)-COLUMN($B$4)\n+ROW($B$4), ROW(B8)-ROW($B$4)+COLUMN($B$4)))","v":"Shampoo"},{"$f":"INDIRECT(ADDRESS(COLUMN(C8)-COLUMN($B$4)\n+ROW($B$4), ROW(C8)-ROW($B$4)+COLUMN($B$4)))","v":320}]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo",null,null,null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320,null,null,null,"Price",180,210,350,320]
[]
[null,"Product Name","Price"]
[null,"Face Wash",180]
[null,"Lipstick",210]
[null,"Conditioner",350]
[null,"Shampoo",320]

{"sheet":"Power Query","index":5,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Use of Power Query",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo",null,null,null,"Product Name","Face Wash","Lipstick","Conditioner","Shampoo"]
[null,"Price",180,210,350,320,null,null,null,"Price",180,210,350,320]

{"sheet":"Table2","index":6,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Product Name","Price"]
["Face Wash",180]
["Lipstick",210]
["Conditioner",350]
["Shampoo",320]