{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Data","Flash Fill Consolidating","Consolidating with &","Consolidating with CONCATENATE","Consolidating with textjoin","Consolidating Altering Rows","Consolidating Altering Rows (2)","VBA"],"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":"Sample Data","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Consolidating Columns in Excel"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"Walter ","Kohn"]
[null,"Roger ","Kornberg "]
[null,"Michael ","Kremer"]
[null,"Eric","Maskin"]
[null,"David","Morris"]
[null,"Craig ","Mello"]
[null,"Merton","Miller "]
[null,"George ","Minot"]
[null,"David","Morse "]
[null,"Ben ","Mottelson "]
[null,"William ","Murphy "]

{"sheet":"Flash Fill Consolidating","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7]]}
[]
[null,"Consolidating Columns in Excel"]
[]
[null,"First Name","Last Name","Full Name",null,">> Practice Here!"]
[null,"Walter ","Kohn","Walter Kohn"]
[null,"Roger ","Kornberg ","Roger Kornberg",null,"First Name","Last Name","Full Name"]
[null,"Michael ","Kremer","Michael Kremer",null,"Walter ","Kohn"]
[null,"Eric","Maskin","Eric Maskin",null,"Roger ","Kornberg "]
[null,"David","Morris","David Morris",null,"Michael ","Kremer"]
[null,"Craig ","Mello","Craig Mello",null,"Eric","Maskin"]
[null,"Merton","Miller ","Merton Miller",null,"David","Morris"]
[null,"George ","Minot","George Minot",null,"Craig ","Mello"]
[null,"David","Morse ","David Morse",null,"Merton","Miller "]
[null,"Ben ","Mottelson ","Ben Mottelson",null,"George ","Minot"]
[null,"William ","Murphy ","William Murphy",null,"David","Morse "]
[null,null,null,null,null,"Ben ","Mottelson "]
[null,null,null,null,null,"William ","Murphy "]

{"sheet":"Consolidating with &","index":2,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7]]}
[]
[null,"Consolidating Columns in Excel"]
[]
[null,"First Name","Last Name","Full Name",null,">> Practice Here!"]
[null,"Walter ","Kohn",{"$f":"B5&\" \"&C5","v":"Walter  Kohn"}]
[null,"Roger ","Kornberg ",{"$f":"B6&\" \"&C6","v":"Roger  Kornberg "},null,"First Name","Last Name","Full Name"]
[null,"Michael ","Kremer","Michael  Kremer",null,"Walter ","Kohn"]
[null,"Eric","Maskin","Eric Maskin",null,"Roger ","Kornberg "]
[null,"David","Morris","David Morris",null,"Michael ","Kremer"]
[null,"Craig ","Mello","Craig  Mello",null,"Eric","Maskin"]
[null,"Merton","Miller ","Merton Miller ",null,"David","Morris"]
[null,"George ","Minot","George  Minot",null,"Craig ","Mello"]
[null,"David","Morse ","David Morse ",null,"Merton","Miller "]
[null,"Ben ","Mottelson ","Ben  Mottelson ",null,"George ","Minot"]
[null,"William ","Murphy ","William  Murphy ",null,"David","Morse "]
[null,null,null,null,null,"Ben ","Mottelson "]
[null,null,null,null,null,"William ","Murphy "]

{"sheet":"Consolidating with CONCATENATE","index":3,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7]]}
[]
[null,"Consolidating Columns in Excel"]
[]
[null,"First Name","Last Name","Full Name",null,">> Practice Here!"]
[null,"Walter ","Kohn",{"$f":"CONCATENATE(B5,C5)","v":"Walter Kohn"}]
[null,"Roger ","Kornberg ",{"$f":"CONCATENATE(B6,C6)","v":"Roger Kornberg "},null,"First Name","Last Name","Full Name"]
[null,"Michael ","Kremer","Michael Kremer",null,"Walter ","Kohn"]
[null,"Eric","Maskin","EricMaskin",null,"Roger ","Kornberg "]
[null,"David","Morris","DavidMorris",null,"Michael ","Kremer"]
[null,"Craig ","Mello","Craig Mello",null,"Eric","Maskin"]
[null,"Merton","Miller ","MertonMiller ",null,"David","Morris"]
[null,"George ","Minot","George Minot",null,"Craig ","Mello"]
[null,"David","Morse ","DavidMorse ",null,"Merton","Miller "]
[null,"Ben ","Mottelson ","Ben Mottelson ",null,"George ","Minot"]
[null,"William ","Murphy ","William Murphy ",null,"David","Morse "]
[null,null,null,null,null,"Ben ","Mottelson "]
[null,null,null,null,null,"William ","Murphy "]

{"sheet":"Consolidating with textjoin","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7]]}
[]
[null,"Consolidating Columns in Excel"]
[]
[null,"First Name","Last Name","Full Name",null,">> Practice Here!"]
[null,"Walter ","Kohn",{"$f":"_xlfn.TEXTJOIN( ,TRUE,B5,C5)","v":"Walter Kohn"}]
[null,"Roger ","Kornberg ",{"$f":"_xlfn.TEXTJOIN( ,TRUE,B6,C6)","v":"Roger Kornberg "},null,"First Name","Last Name","Full Name"]
[null,"Michael ","Kremer","Michael Kremer",null,"Walter ","Kohn"]
[null,"Eric","Maskin","EricMaskin",null,"Roger ","Kornberg "]
[null,"David","Morris","DavidMorris",null,"Michael ","Kremer"]
[null,"Craig ","Mello","Craig Mello",null,"Eric","Maskin"]
[null,"Merton","Miller ","MertonMiller ",null,"David","Morris"]
[null,"George ","Minot","George Minot",null,"Craig ","Mello"]
[null,"David","Morse ","DavidMorse ",null,"Merton","Miller "]
[null,"Ben ","Mottelson ","Ben Mottelson ",null,"George ","Minot"]
[null,"William ","Murphy ","William Murphy ",null,"David","Morse "]
[null,null,null,null,null,"Ben ","Mottelson "]
[null,null,null,null,null,"William ","Murphy "]

{"sheet":"Consolidating Altering Rows","index":5,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7]]}
[]
[null,"Consolidating Columns in Excel"]
[]
[null,"Products","Products","Products",null,">> Practice Here!"]
[null,"Product-1","Product-7",{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D5:$D$5)), IFERROR(INDEX($C$5:$C$11, ROWS(D5:$D$5)-ROWS($B$5:$B$10)),\"\"))","v":"Product-1"}]
[null,"Product-2","Product-8",{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D6)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D6)-ROWS($B$5:$B$10)),\"\"))","v":"Product-2"},null,"Products","Products","Products"]
[null,"Product-3","Product-9",{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D7)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D7)-ROWS($B$5:$B$10)),\"\"))","v":"Product-3"},null,"Product-1","Product-7"]
[null,"Product-4","Product-10",{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D8)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D8)-ROWS($B$5:$B$10)),\"\"))","v":"Product-4"},null,"Product-2","Product-8"]
[null,"Product-5","Product-11",{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D9)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D9)-ROWS($B$5:$B$10)),\"\"))","v":"Product-5"},null,"Product-3","Product-9"]
[null,"Product-6","Product-12",{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D10)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D10)-ROWS($B$5:$B$10)),\"\"))","v":"Product-6"},null,"Product-4","Product-10"]
[null,null,"Product-13",{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D11)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D11)-ROWS($B$5:$B$10)),\"\"))","v":"Product-7"},null,"Product-5","Product-11"]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D12)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D12)-ROWS($B$5:$B$10)),\"\"))","v":"Product-8"},null,"Product-6","Product-12"]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D13)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D13)-ROWS($B$5:$B$10)),\"\"))","v":"Product-9"},null,null,"Product-13"]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D14)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D14)-ROWS($B$5:$B$10)),\"\"))","v":"Product-10"}]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D15)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D15)-ROWS($B$5:$B$10)),\"\"))","v":"Product-11"}]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D16)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D16)-ROWS($B$5:$B$10)),\"\"))","v":"Product-12"}]
[null,null,null,{"$f":"IFERROR(INDEX($B$5:$B$10, ROWS(D$5:$D17)), IFERROR(INDEX($C$5:$C$11, ROWS(D$5:$D17)-ROWS($B$5:$B$10)),\"\"))","v":"Product-13"}]

{"sheet":"Consolidating Altering Rows (2)","index":6,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7]]}
[]
[null,"Consolidating Columns in Excel"]
[]
[null,"Products","Products","Products",null,">> Practice Here!"]
[null,"Product-1","Product-6",{"$f":"IF(B6<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Product-1"}]
[null,"Product-2","Product-7",{"$f":"IF(B7<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Product-2"},null,"Products","Products","Products"]
[null,"Product-3","Product-8",{"$f":"IF(B8<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Product-3"},null,"Product-1","Product-6"]
[null,"Product-4","Product-9",{"$f":"IF(B9<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Product-4"},null,"Product-2","Product-7"]
[null,"Product-5",null,{"$f":"IF(B10<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Product-6"},null,"Product-3","Product-8"]
[null,null,null,{"$f":"IF(B11<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Product-7"},null,"Product-4","Product-9"]
[null,null,null,{"$f":"IF(B12<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Product-8"},null,"Product-5"]
[null,null,null,{"$f":"IF(B13<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":"Product-9"}]
[null,null,null,{"$f":"IF(B14<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":0}]
[null,null,null,{"$f":"IF(B15<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":0}]
[null,null,null,{"$f":"IF(B16<>\"\",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-ROW($D$8)))","v":0}]

{"sheet":"VBA","index":7,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7]]}
[]
[null,"Consolidating Columns in Excel"]
[]
[null,"Products","Products","Products",null,">> Practice Here!"]
[null,"Product-1"]
[null,"Product-2",null,null,null,"Products","Products","Products"]
[null,"Product-3",null,null,null,"Product-1","Product-6"]
[null,"Product-4",null,null,null,"Product-2","Product-7"]
[null,"Product-5",null,null,null,"Product-3","Product-8"]
[null,"Product-6",null,null,null,"Product-4","Product-9"]
[null,"Product-7",null,null,null,"Product-5"]
[null,"Product-8"]