{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["dataset","transpose","combined","Cell Reference","index","indirect","vba","Diy"],"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Transpose Column to Multiple Rows"]
[]
[null,"Customer ID","Name","Product"]
[null,"012A","James","Laptop"]
[null,"003A","Frank","Desktop"]
[null,"013B","Dave","Smartphone"]
[null,"004A","Fred","TV"]
[null,"009B","Cantor","Laptop"]
[null,"020A","Samuel","Graphics Card"]

{"sheet":"transpose","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using TRANSPOSE Function"]
[]
[null,"Customer ID","Name","Product"]
[null,"012A","James","Laptop"]
[null,"003A","Frank","Desktop"]
[null,"013B","Dave","Smartphone"]
[null,"004A","Fred","TV"]
[null,"009B","Cantor","Laptop"]
[null,"020A","Samuel","Graphics Card"]
[]
[null,{"$f":"TRANSPOSE(B4:D10)","v":"Customer ID"},"012A","003A","013B","004A","009B","020A"]
[null,"Name","James","Frank","Dave","Fred","Cantor","Samuel"]
[null,"Product","Laptop","Desktop","Smartphone","TV","Laptop","Graphics Card"]

{"sheet":"combined","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,13,1]]}
[]
[null,"Using Combined Function"]
[]
[null,"Customer ID","Name","Product"]
[null,"012A","James","Laptop"]
[null,"003A","Frank","Desktop"]
[null,"013B","Dave","Smartphone"]
[null,"004A","Fred","TV"]
[null,"009B","Cantor","Laptop"]
[null,"020A","Samuel","Graphics Card"]
[]
[null,"Customer ID",{"$f":"OFFSET($B$5,COLUMNS($B:B)-1+(ROWS($5:5)-1)*2,0)","v":"012A"},{"$f":"OFFSET($B$5,COLUMNS($B:C)-1+(ROWS($5:5)-1)*2,0)","v":"003A"}]
[null,null,{"$f":"OFFSET($B$5,COLUMNS($B:B)-1+(ROWS($5:6)-1)*2,0)","v":"013B"},{"$f":"OFFSET($B$5,COLUMNS($B:C)-1+(ROWS($5:6)-1)*2,0)","v":"004A"}]
[null,null,{"$f":"OFFSET($B$5,COLUMNS($B:B)-1+(ROWS($5:7)-1)*2,0)","v":"009B"},{"$f":"OFFSET($B$5,COLUMNS($B:C)-1+(ROWS($5:7)-1)*2,0)","v":"020A"}]

{"sheet":"Cell Reference","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Cell Reference"]
[]
[null,"Customer ID","Name","Product"]
[null,"012A","James","Laptop"]
[null,"003A","Frank","Desktop"]
[null,"013B","Dave","Smartphone"]
[null,"004A","Fred","TV"]
[null,"009B","Cantor","Laptop"]
[null,"020A","Samuel","Graphics Card"]
[]
[null,{"$f":"B4","v":"Customer ID"},{"$f":"B5","v":"012A"},{"$f":"B6","v":"003A"},{"$f":"B7","v":"013B"},{"$f":"B8","v":"004A"},{"$f":"B9","v":"009B"},{"$f":"B10","v":"020A"}]
[null,{"$f":"C4","v":"Name"},{"$f":"C5","v":"James"},{"$f":"C6","v":"Frank"},{"$f":"C7","v":"Dave"},{"$f":"C8","v":"Fred"},{"$f":"C9","v":"Cantor"},{"$f":"C10","v":"Samuel"}]
[null,{"$f":"D4","v":"Product"},{"$f":"D5","v":"Laptop"},{"$f":"D6","v":"Desktop"},{"$f":"D7","v":"Smartphone"},{"$f":"D8","v":"TV"},{"$f":"D9","v":"Laptop"},{"$f":"D10","v":"Graphics Card"}]

{"sheet":"index","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of INDEX Function"]
[]
[null,"Customer ID","Name","Product"]
[null,"012A","James","Laptop"]
[null,"003A","Frank","Desktop"]
[null,"013B","Dave","Smartphone"]
[null,"004A","Fred","TV"]
[null,"009B","Cantor","Laptop"]
[null,"020A","Samuel","Graphics Card"]
[]
[null,{"$f":"INDEX($B$3:$D$10,COLUMN(B1),1)","v":"Customer ID"},{"$f":"INDEX($B$3:$D$10,COLUMN(C1),1)","v":"012A"},{"$f":"INDEX($B$3:$D$10,COLUMN(D1),1)","v":"003A"},{"$f":"INDEX($B$3:$D$10,COLUMN(E1),1)","v":"013B"},{"$f":"INDEX($B$3:$D$10,COLUMN(F1),1)","v":"004A"},{"$f":"INDEX($B$3:$D$10,COLUMN(G1),1)","v":"009B"},{"$f":"INDEX($B$3:$D$10,COLUMN(H1),1)","v":"020A"}]
[null,{"$f":"INDEX($B$3:$D$10,COLUMN(B1),2)","v":"Name"},{"$f":"INDEX($B$3:$D$10,COLUMN(C1),2)","v":"James"},{"$f":"INDEX($B$3:$D$10,COLUMN(D1),2)","v":"Frank"},{"$f":"INDEX($B$3:$D$10,COLUMN(E1),2)","v":"Dave"},{"$f":"INDEX($B$3:$D$10,COLUMN(F1),2)","v":"Fred"},{"$f":"INDEX($B$3:$D$10,COLUMN(G1),2)","v":"Cantor"},{"$f":"INDEX($B$3:$D$10,COLUMN(H1),2)","v":"Samuel"}]
[null,{"$f":"INDEX($B$3:$D$10,COLUMN(B1),3)","v":"Product"},{"$f":"INDEX($B$3:$D$10,COLUMN(C1),3)","v":"Laptop"},{"$f":"INDEX($B$3:$D$10,COLUMN(D1),3)","v":"Desktop"},{"$f":"INDEX($B$3:$D$10,COLUMN(E1),3)","v":"Smartphone"},{"$f":"INDEX($B$3:$D$10,COLUMN(F1),3)","v":"TV"},{"$f":"INDEX($B$3:$D$10,COLUMN(G1),3)","v":"Laptop"},{"$f":"INDEX($B$3:$D$10,COLUMN(H1),3)","v":"Graphics Card"}]

{"sheet":"indirect","index":5,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using INDIRECT Function"]
[]
[null,"Customer ID","Name","Product"]
[null,"012A","James","Laptop"]
[null,"003A","Frank","Desktop"]
[null,"013B","Dave","Smartphone"]
[null,"004A","Fred","TV"]
[null,"009B","Cantor","Laptop"]
[null,"020A","Samuel","Graphics Card"]
[]
[null,{"$f":"INDIRECT(\"B\"&COLUMN(D5))","v":"Customer ID"},{"$f":"INDIRECT(\"B\"&COLUMN(E5))","v":"012A"},{"$f":"INDIRECT(\"B\"&COLUMN(F5))","v":"003A"},{"$f":"INDIRECT(\"B\"&COLUMN(G5))","v":"013B"},{"$f":"INDIRECT(\"B\"&COLUMN(H5))","v":"004A"},{"$f":"INDIRECT(\"B\"&COLUMN(I5))","v":"009B"},{"$f":"INDIRECT(\"B\"&COLUMN(J5))","v":"020A"}]
[null,{"$f":"INDIRECT(\"C\"&COLUMN(D5))","v":"Name"},{"$f":"INDIRECT(\"C\"&COLUMN(E5))","v":"James"},{"$f":"INDIRECT(\"C\"&COLUMN(F5))","v":"Frank"},{"$f":"INDIRECT(\"C\"&COLUMN(G5))","v":"Dave"},{"$f":"INDIRECT(\"C\"&COLUMN(H5))","v":"Fred"},{"$f":"INDIRECT(\"C\"&COLUMN(I5))","v":"Cantor"},{"$f":"INDIRECT(\"C\"&COLUMN(J5))","v":"Samuel"}]
[null,{"$f":"INDIRECT(\"D\"&COLUMN(D5))","v":"Product"},{"$f":"INDIRECT(\"D\"&COLUMN(E5))","v":"Laptop"},{"$f":"INDIRECT(\"D\"&COLUMN(F5))","v":"Desktop"},{"$f":"INDIRECT(\"D\"&COLUMN(G5))","v":"Smartphone"},{"$f":"INDIRECT(\"D\"&COLUMN(H5))","v":"TV"},{"$f":"INDIRECT(\"D\"&COLUMN(I5))","v":"Laptop"},{"$f":"INDIRECT(\"D\"&COLUMN(J5))","v":"Graphics Card"}]

{"sheet":"vba","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,13,1]]}
[]
[null,"Use of VBA"]
[]
[null,"Customer ID","Name","Product"]
[null,"012A","James","Laptop"]
[null,"003A","Frank","Desktop"]
[null,"013B","Dave","Smartphone"]
[null,"004A","Fred","TV"]
[null,"009B","Cantor","Laptop"]
[null,"020A","Samuel","Graphics Card"]
[]
[null,"Customer ID","012A","003A"]
[null,null,"013B","004A"]
[null,null,"009B","020A"]

{"sheet":"Diy","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Do It Yourself"]
[]
[null,"Customer ID","Name","Product"]
[null,"012A","James","Laptop"]
[null,"003A","Frank","Desktop"]
[null,"013B","Dave","Smartphone"]
[null,"004A","Fred","TV"]
[null,"009B","Cantor","Laptop"]
[null,"020A","Samuel","Graphics Card"]