{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Paste Special","Find & Replace","Power Query","TRANSPOSE Function","OFFSET Function","VLOOKUP Function","INDEX Function","INDIRECT, ADDRESS","VBA","Switch Columns","Swap Rows"],"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":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Employee Information"]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]

{"sheet":"Paste Special","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Paste Special Feature"]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]
[]
[null,"Employee ID","Full Name","Designation","Department","Annual Salary"]
[null,"999-7501","Robin Mitchell","Asst. Manager","Sales",94876]
[null,"999-7502","Mary Thompson","Production Manager","Manufacturing",150820]
[null,"999-7503","Jones Williams","IT Executive","Corporate",64588]
[null,"999-7504","Susan Scott","Protocol Officer","R&D",72456]
[null,"999-7505","James Garcia","Analyst","Sales",121650]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]

{"sheet":"Find & Replace","index":2,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Utilizing Find & Replace Feature"]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]
[]
[null,"xxB4","xxC4","xxD4","xxE4","xxF4","xxG4"]
[null,"xxB5","xxC5","xxD5","xxE5","xxF5","xxG5"]
[null,"xxB6","xxC6","xxD6","xxE6","xxF6","xxG6"]
[null,"xxB7","xxC7","xxD7","xxE7","xxF7","xxG7"]
[null,"xxB8","xxC8","xxD8","xxE8","xxF8","xxG8"]
[]
[null,{"$f":"B4","v":"Employee ID"},{"$f":"B5","v":"Full Name"},{"$f":"B6","v":"Designation"},{"$f":"B7","v":"Department"},{"$f":"B8","v":"Annual Salary"}]
[null,{"$f":"C4","v":"999-7501"},{"$f":"C5","v":"Robin Mitchell"},{"$f":"C6","v":"Asst. Manager"},{"$f":"C7","v":"Sales"},{"$f":"C8","v":94876}]
[null,{"$f":"D4","v":"999-7502"},{"$f":"D5","v":"Mary Thompson"},{"$f":"D6","v":"Production Manager"},{"$f":"D7","v":"Manufacturing"},{"$f":"D8","v":150820}]
[null,{"$f":"E4","v":"999-7503"},{"$f":"E5","v":"Jones Williams"},{"$f":"E6","v":"IT Executive"},{"$f":"E7","v":"Corporate"},{"$f":"E8","v":64588}]
[null,{"$f":"F4","v":"999-7504"},{"$f":"F5","v":"Susan Scott"},{"$f":"F6","v":"Protocol Officer"},{"$f":"F7","v":"R&D"},{"$f":"F8","v":72456}]
[null,{"$f":"G4","v":"999-7505"},{"$f":"G5","v":"James Garcia"},{"$f":"G6","v":"Analyst"},{"$f":"G7","v":"Sales"},{"$f":"G8","v":121650}]

{"sheet":"Power Query","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Power Query Editor"]
[]
[null,"Column1","Column2","Column3","Column4","Column5","Column6"]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]
[]
[null,"Employee ID","Full Name","Designation","Department","Annual Salary"]
[null,"999-7501","Robin Mitchell","Asst. Manager","Sales",94876]
[null,"999-7502","Mary Thompson","Production Manager","Manufacturing",150820]
[null,"999-7503","Jones Williams","IT Executive","Corporate",64588]
[null,"999-7504","Susan Scott","Protocol Officer","R&D",72456]
[null,"999-7505","James Garcia","Analyst","Sales",121650]

{"sheet":"TRANSPOSE Function","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using TRANSPOSE Function to Update Data Automatically"]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]
[]
[null,{"$f":"TRANSPOSE(B4:G8)","v":"Employee ID"},"Full Name","Designation","Department","Annual Salary"]
[null,"999-7501","Robin Mitchell","Asst. Manager","Sales",94876]
[null,"999-7502","Mary Thompson","Production Manager","Manufacturing",150820]
[null,"999-7503","Jones Williams","IT Executive","Corporate",64588]
[null,"999-7504","Susan Scott","Protocol Officer","R&D",72456]
[null,"999-7505","James Garcia","Analyst","Sales",121650]

{"sheet":"OFFSET Function","index":5,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using OFFSET Function to Swap Columns and Rows"]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]
[]
[null,0,1,2,3,4]
[0,{"$f":"OFFSET($B$4,B$10,$A11)","v":"Employee ID"},{"$f":"OFFSET($B$4,C$10,$A11)","v":"Full Name"},"Designation","Department","Annual Salary"]
[1,{"$f":"OFFSET($B$4,B$10,$A12)","v":"999-7501"},"Robin Mitchell","Asst. Manager","Sales",94876]
[2,"999-7502","Mary Thompson","Production Manager","Manufacturing",150820]
[3,"999-7503","Jones Williams","IT Executive","Corporate",64588]
[4,"999-7504","Susan Scott","Protocol Officer","R&D",72456]
[5,"999-7505","James Garcia","Analyst","Sales",121650]

{"sheet":"VLOOKUP Function","index":6,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using VLOOKUP Function with Manual Inputs"]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]
[]
[null,"Employee ID","Full Name","Designation","Department","Annual Salary"]
[null,"999-7501",{"$f":"VLOOKUP($B11,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Robin Mitchell"},{"$f":"VLOOKUP($B11,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Asst. Manager"},{"$f":"VLOOKUP($B11,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Sales"},{"$f":"VLOOKUP($B11,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":94876}]
[null,"999-7502",{"$f":"VLOOKUP($B12,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Mary Thompson"},{"$f":"VLOOKUP($B12,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Production Manager"},{"$f":"VLOOKUP($B12,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Manufacturing"},{"$f":"VLOOKUP($B12,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":150820}]
[null,"999-7503",{"$f":"VLOOKUP($B13,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Jones Williams"},{"$f":"VLOOKUP($B13,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"IT Executive"},{"$f":"VLOOKUP($B13,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Corporate"},{"$f":"VLOOKUP($B13,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":64588}]
[null,"999-7504",{"$f":"VLOOKUP($B14,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Susan Scott"},{"$f":"VLOOKUP($B14,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Protocol Officer"},{"$f":"VLOOKUP($B14,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"R&D"},{"$f":"VLOOKUP($B14,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":72456}]
[null,"999-7505",{"$f":"VLOOKUP($B15,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"James Garcia"},{"$f":"VLOOKUP($B15,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Analyst"},{"$f":"VLOOKUP($B15,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":"Sales"},{"$f":"VLOOKUP($B15,TRANSPOSE($C$4:$G$8),COLUMN()-1,FALSE)","v":121650}]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name",{"$f":"VLOOKUP($B18,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Robin Mitchell"},{"$f":"VLOOKUP($B18,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Mary Thompson"},{"$f":"VLOOKUP($B18,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Jones Williams"},{"$f":"VLOOKUP($B18,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Susan Scott"},{"$f":"VLOOKUP($B18,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"James Garcia"}]
[null,"Designation",{"$f":"VLOOKUP($B19,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Asst. Manager"},{"$f":"VLOOKUP($B19,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Production Manager"},{"$f":"VLOOKUP($B19,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"IT Executive"},{"$f":"VLOOKUP($B19,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Protocol Officer"},{"$f":"VLOOKUP($B19,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Analyst"}]
[null,"Department",{"$f":"VLOOKUP($B20,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Sales"},{"$f":"VLOOKUP($B20,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Manufacturing"},{"$f":"VLOOKUP($B20,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Corporate"},{"$f":"VLOOKUP($B20,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"R&D"},{"$f":"VLOOKUP($B20,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":"Sales"}]
[null,"Annual Salary",{"$f":"VLOOKUP($B21,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":94876},{"$f":"VLOOKUP($B21,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":150820},{"$f":"VLOOKUP($B21,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":64588},{"$f":"VLOOKUP($B21,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":72456},{"$f":"VLOOKUP($B21,TRANSPOSE($C$10:$F$15),COLUMN()-1,FALSE)","v":121650}]

{"sheet":"INDEX Function","index":7,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using INDEX Function"]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]
[]
[null,{"$f":"INDEX($B$4:$G$8,COLUMN(A1),ROW(A1))","v":"Employee ID"},{"$f":"INDEX($B$4:$G$8,COLUMN(B1),ROW(B1))","v":"Full Name"},{"$f":"INDEX($B$4:$G$8,COLUMN(C1),ROW(C1))","v":"Designation"},{"$f":"INDEX($B$4:$G$8,COLUMN(D1),ROW(D1))","v":"Department"},{"$f":"INDEX($B$4:$G$8,COLUMN(E1),ROW(E1))","v":"Annual Salary"}]
[null,{"$f":"INDEX($B$4:$G$8,COLUMN(A2),ROW(A2))","v":"999-7501"},{"$f":"INDEX($B$4:$G$8,COLUMN(B2),ROW(B2))","v":"Robin Mitchell"},{"$f":"INDEX($B$4:$G$8,COLUMN(C2),ROW(C2))","v":"Asst. Manager"},{"$f":"INDEX($B$4:$G$8,COLUMN(D2),ROW(D2))","v":"Sales"},{"$f":"INDEX($B$4:$G$8,COLUMN(E2),ROW(E2))","v":94876}]
[null,{"$f":"INDEX($B$4:$G$8,COLUMN(A3),ROW(A3))","v":"999-7502"},{"$f":"INDEX($B$4:$G$8,COLUMN(B3),ROW(B3))","v":"Mary Thompson"},{"$f":"INDEX($B$4:$G$8,COLUMN(C3),ROW(C3))","v":"Production Manager"},{"$f":"INDEX($B$4:$G$8,COLUMN(D3),ROW(D3))","v":"Manufacturing"},{"$f":"INDEX($B$4:$G$8,COLUMN(E3),ROW(E3))","v":150820}]
[null,{"$f":"INDEX($B$4:$G$8,COLUMN(A4),ROW(A4))","v":"999-7503"},{"$f":"INDEX($B$4:$G$8,COLUMN(B4),ROW(B4))","v":"Jones Williams"},{"$f":"INDEX($B$4:$G$8,COLUMN(C4),ROW(C4))","v":"IT Executive"},{"$f":"INDEX($B$4:$G$8,COLUMN(D4),ROW(D4))","v":"Corporate"},{"$f":"INDEX($B$4:$G$8,COLUMN(E4),ROW(E4))","v":64588}]
[null,{"$f":"INDEX($B$4:$G$8,COLUMN(A5),ROW(A5))","v":"999-7504"},{"$f":"INDEX($B$4:$G$8,COLUMN(B5),ROW(B5))","v":"Susan Scott"},{"$f":"INDEX($B$4:$G$8,COLUMN(C5),ROW(C5))","v":"Protocol Officer"},{"$f":"INDEX($B$4:$G$8,COLUMN(D5),ROW(D5))","v":"R&D"},{"$f":"INDEX($B$4:$G$8,COLUMN(E5),ROW(E5))","v":72456}]
[null,{"$f":"INDEX($B$4:$G$8,COLUMN(A6),ROW(A6))","v":"999-7505"},{"$f":"INDEX($B$4:$G$8,COLUMN(B6),ROW(B6))","v":"James Garcia"},{"$f":"INDEX($B$4:$G$8,COLUMN(C6),ROW(C6))","v":"Analyst"},{"$f":"INDEX($B$4:$G$8,COLUMN(D6),ROW(D6))","v":"Sales"},{"$f":"INDEX($B$4:$G$8,COLUMN(E6),ROW(E6))","v":121650}]

{"sheet":"INDIRECT, ADDRESS","index":8,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Combining INDIRECT and ADDRESS Functions to Swap Columns and Rows"]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]
[]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B4)-COLUMN($B$4)+ROW($B$4), ROW(B4)-ROW($B$4)+COLUMN($B$4)))","v":"Employee ID"},{"$f":"INDIRECT(ADDRESS(COLUMN(C4)-COLUMN($B$4)+ROW($B$4), ROW(C4)-ROW($B$4)+COLUMN($B$4)))","v":"Full Name"},{"$f":"INDIRECT(ADDRESS(COLUMN(D4)-COLUMN($B$4)+ROW($B$4), ROW(D4)-ROW($B$4)+COLUMN($B$4)))","v":"Designation"},{"$f":"INDIRECT(ADDRESS(COLUMN(E4)-COLUMN($B$4)+ROW($B$4), ROW(E4)-ROW($B$4)+COLUMN($B$4)))","v":"Department"},{"$f":"INDIRECT(ADDRESS(COLUMN(F4)-COLUMN($B$4)+ROW($B$4), ROW(F4)-ROW($B$4)+COLUMN($B$4)))","v":"Annual Salary"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B5)-COLUMN($B$4)+ROW($B$4), ROW(B5)-ROW($B$4)+COLUMN($B$4)))","v":"999-7501"},{"$f":"INDIRECT(ADDRESS(COLUMN(C5)-COLUMN($B$4)+ROW($B$4), ROW(C5)-ROW($B$4)+COLUMN($B$4)))","v":"Robin Mitchell"},{"$f":"INDIRECT(ADDRESS(COLUMN(D5)-COLUMN($B$4)+ROW($B$4), ROW(D5)-ROW($B$4)+COLUMN($B$4)))","v":"Asst. Manager"},{"$f":"INDIRECT(ADDRESS(COLUMN(E5)-COLUMN($B$4)+ROW($B$4), ROW(E5)-ROW($B$4)+COLUMN($B$4)))","v":"Sales"},{"$f":"INDIRECT(ADDRESS(COLUMN(F5)-COLUMN($B$4)+ROW($B$4), ROW(F5)-ROW($B$4)+COLUMN($B$4)))","v":94876}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B6)-COLUMN($B$4)+ROW($B$4), ROW(B6)-ROW($B$4)+COLUMN($B$4)))","v":"999-7502"},{"$f":"INDIRECT(ADDRESS(COLUMN(C6)-COLUMN($B$4)+ROW($B$4), ROW(C6)-ROW($B$4)+COLUMN($B$4)))","v":"Mary Thompson"},{"$f":"INDIRECT(ADDRESS(COLUMN(D6)-COLUMN($B$4)+ROW($B$4), ROW(D6)-ROW($B$4)+COLUMN($B$4)))","v":"Production Manager"},{"$f":"INDIRECT(ADDRESS(COLUMN(E6)-COLUMN($B$4)+ROW($B$4), ROW(E6)-ROW($B$4)+COLUMN($B$4)))","v":"Manufacturing"},{"$f":"INDIRECT(ADDRESS(COLUMN(F6)-COLUMN($B$4)+ROW($B$4), ROW(F6)-ROW($B$4)+COLUMN($B$4)))","v":150820}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B7)-COLUMN($B$4)+ROW($B$4), ROW(B7)-ROW($B$4)+COLUMN($B$4)))","v":"999-7503"},{"$f":"INDIRECT(ADDRESS(COLUMN(C7)-COLUMN($B$4)+ROW($B$4), ROW(C7)-ROW($B$4)+COLUMN($B$4)))","v":"Jones Williams"},{"$f":"INDIRECT(ADDRESS(COLUMN(D7)-COLUMN($B$4)+ROW($B$4), ROW(D7)-ROW($B$4)+COLUMN($B$4)))","v":"IT Executive"},{"$f":"INDIRECT(ADDRESS(COLUMN(E7)-COLUMN($B$4)+ROW($B$4), ROW(E7)-ROW($B$4)+COLUMN($B$4)))","v":"Corporate"},{"$f":"INDIRECT(ADDRESS(COLUMN(F7)-COLUMN($B$4)+ROW($B$4), ROW(F7)-ROW($B$4)+COLUMN($B$4)))","v":64588}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B8)-COLUMN($B$4)+ROW($B$4), ROW(B8)-ROW($B$4)+COLUMN($B$4)))","v":"999-7504"},{"$f":"INDIRECT(ADDRESS(COLUMN(C8)-COLUMN($B$4)+ROW($B$4), ROW(C8)-ROW($B$4)+COLUMN($B$4)))","v":"Susan Scott"},{"$f":"INDIRECT(ADDRESS(COLUMN(D8)-COLUMN($B$4)+ROW($B$4), ROW(D8)-ROW($B$4)+COLUMN($B$4)))","v":"Protocol Officer"},{"$f":"INDIRECT(ADDRESS(COLUMN(E8)-COLUMN($B$4)+ROW($B$4), ROW(E8)-ROW($B$4)+COLUMN($B$4)))","v":"R&D"},{"$f":"INDIRECT(ADDRESS(COLUMN(F8)-COLUMN($B$4)+ROW($B$4), ROW(F8)-ROW($B$4)+COLUMN($B$4)))","v":72456}]

{"sheet":"VBA","index":9,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Applying VBA Code to Swap Columns and Rows"]
[]
[null,"Employee ID","999-7501","999-7502","999-7503","999-7504","999-7505"]
[null,"Full Name","Robin Mitchell","Mary Thompson","Jones Williams","Susan Scott","James Garcia"]
[null,"Designation","Asst. Manager","Production Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Sales","Manufacturing","Corporate","R&D","Sales"]
[null,"Annual Salary",94876,150820,64588,72456,121650]
[]
[null,"Employee ID","Full Name","Designation","Department","Annual Salary"]
[null,"999-7501","Robin Mitchell","Asst. Manager","Sales",94876]
[null,"999-7502","Mary Thompson","Production Manager","Manufacturing",150820]
[null,"999-7503","Jones Williams","IT Executive","Corporate",64588]
[null,"999-7504","Susan Scott","Protocol Officer","R&D",72456]
[null,"999-7505","James Garcia","Analyst","Sales",121650]

{"sheet":"Switch Columns","index":10,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Switching Between Columns"]
[]
[null,"Employee ID","999-7502","999-7501","999-7503","999-7504","999-7505"]
[null,"Designation","Production Manager","Asst. Manager","IT Executive","Protocol Officer","Analyst"]
[null,"Department","Manufacturing","Sales","Corporate","R&D","Sales"]
[null,"Full Name","Mary Thompson","Robin Mitchell","Jones Williams","Susan Scott","James Garcia"]
[null,"Annual Salary",150820,94876,64588,72456,121650]

{"sheet":"Swap Rows","index":11,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Swapping Rows"]
[]
[null,"Employee ID","999-7501","999-7503","999-7504","999-7502","999-7505"]
[null,"Full Name","Robin Mitchell","Jones Williams","Susan Scott","Mary Thompson","James Garcia"]
[null,"Department","Sales","Corporate","R&D","Manufacturing","Sales"]
[null,"Designation","Asst. Manager","IT Executive","Protocol Officer","Production Manager","Analyst"]
[null,"Annual Salary",94876,64588,72456,150820,121650]