{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Approach 1","Approach 2","Approach 3","Approach 4"],"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":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Excel Combine Columns into One List"]
[]
[null,"Names","Names"]
[null,"Adam","John"]
[null,"Ashley","Fransis"]
[null,"Licht","Cook"]
[null,"Angela","Bell"]
[null,"Mike"]
[null,"Henderson"]

{"sheet":"Approach 1","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Excel Combine Columns into One List"]
[]
[null,"Names","Names","Merged List of Names"]
[null,"Adam","John",{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D6:$D$6)), IFERROR(INDEX($C$6:$C$9, ROWS(D6:$D$6)-ROWS($B$6:$B$11)),\"\"))","v":"Adam"}]
[null,"Ashley","Fransis",{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D$6:$D7)), IFERROR(INDEX($C$6:$C$9, ROWS(D$6:$D7)-ROWS($B$6:$B$11)),\"\"))","v":"Ashley"}]
[null,"Licht","Cook",{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D$6:$D8)), IFERROR(INDEX($C$6:$C$9, ROWS(D$6:$D8)-ROWS($B$6:$B$11)),\"\"))","v":"Licht"}]
[null,"Angela","Bell",{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D$6:$D9)), IFERROR(INDEX($C$6:$C$9, ROWS(D$6:$D9)-ROWS($B$6:$B$11)),\"\"))","v":"Angela"}]
[null,"Mike",null,{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D$6:$D10)), IFERROR(INDEX($C$6:$C$9, ROWS(D$6:$D10)-ROWS($B$6:$B$11)),\"\"))","v":"Mike"}]
[null,"Henderson",null,{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D$6:$D11)), IFERROR(INDEX($C$6:$C$9, ROWS(D$6:$D11)-ROWS($B$6:$B$11)),\"\"))","v":"Henderson"}]
[null,null,null,{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D$6:$D12)), IFERROR(INDEX($C$6:$C$9, ROWS(D$6:$D12)-ROWS($B$6:$B$11)),\"\"))","v":"John"}]
[null,null,null,{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D$6:$D13)), IFERROR(INDEX($C$6:$C$9, ROWS(D$6:$D13)-ROWS($B$6:$B$11)),\"\"))","v":"Fransis"}]
[null,null,null,{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D$6:$D14)), IFERROR(INDEX($C$6:$C$9, ROWS(D$6:$D14)-ROWS($B$6:$B$11)),\"\"))","v":"Cook"}]
[null,null,null,{"$f":"IFERROR(INDEX($B$6:$B$11, ROWS(D$6:$D15)), IFERROR(INDEX($C$6:$C$9, ROWS(D$6:$D15)-ROWS($B$6:$B$11)),\"\"))","v":"Bell"}]

{"sheet":"Approach 2","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Excel Combine Columns into One List"]
[]
[null,"Names","Names","Merged List of Names"]
[null,"Adam","John",{"$f":"IF(B6<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"Adam"}]
[null,"Ashley","Fransis",{"$f":"IF(B7<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"Ashley"}]
[null,"Licht","Cook",{"$f":"IF(B8<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"Licht"}]
[null,"Angela","Bell",{"$f":"IF(B9<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"Angela"}]
[null,"Mike","Henderson",{"$f":"IF(B10<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"Mike"}]
[null,null,null,{"$f":"IF(B11<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"John"}]
[null,null,null,{"$f":"IF(B12<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"Fransis"}]
[null,null,null,{"$f":"IF(B13<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"Cook"}]
[null,null,null,{"$f":"IF(B14<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"Bell"}]
[null,null,null,{"$f":"IF(B15<>\"\",INDEX($B$6:$B$1048576,ROW()-COUNTA($B$6:$B$10)),INDEX($C$6:$C$1048576,ROW()-ROW($D$10)))","v":"Henderson"}]

{"sheet":"Approach 3","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Excel Combine Columns into One List"]
[]
[null,"Names","Names","Merged List of Names"]
[null,"Adam","John",{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B6)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B6)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"Adam"}]
[null,"Ashley","Fransis",{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B7)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B7)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"John"}]
[null,"Licht","Cook",{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B8)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B8)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"Ashley"}]
[null,"Angela","Bell",{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B9)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B9)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"Fransis"}]
[null,"Mike","Henderson",{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B10)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B10)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"Licht"}]
[null,null,null,{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B11)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B11)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"Cook"}]
[null,null,null,{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B12)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B12)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"Angela"}]
[null,null,null,{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B13)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B13)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"Bell"}]
[null,null,null,{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B14)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B14)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"Mike"}]
[null,null,null,{"$f":"INDEX($B$6:$C$10,1+INT((ROW(B15)-6)/COLUMNS($B$6:$C$10)),\nMOD(ROW(B15)-6+COLUMNS($B$6:$C$10),COLUMNS($B$6:$C$10))+1)","v":"Henderson"}]

{"sheet":"Approach 4","index":4,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Excel Combine Columns into One List"]
[]
[null,"Names","Names"]
[null,"Adam"]
[null,"Ashley"]
[null,"Licht"]
[null,"Angela"]
[null,"Mike"]
[null,"John"]
[null,"Fransis"]
[null,"Cook"]
[null,"Bell"]
[null,"Henderson"]