{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Contiguous Columns","Columns Go Forever","Using Formula","Columns Having Certain Text","Columns Having No Data","Power Query with edit","Power Query","Deleting Cells"],"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":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Deleting Cells"]
[]
[null,"Name/Sales","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"]
[null,"John",772,685,481,505,507,691,440,510,576]
[null,"Roman",437,312,470,741,722,448,361,704,468]
[null,"Finn",447,414,630,784,754,543,373,573,339]
[null,"Seth",760,661,745,675,654,501,775,619,347]
[null,"Dean",334,351,643,633,564,520,569,610,745]
[null,"Brock",304,615,320,546,432,629,763,746,786]
[null,"Edge",711,702,357,494,576,578,515,610,637]
[null,"Rock",318,592,591,437,382,659,605,431,532]
[null,"Paul",638,593,604,582,605,355,656,789,742]

{"sheet":"Contiguous Columns","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Context Menu Bar to Remove Multiple Contiguous Columns"]
[]
[null,"Name/Sales","Jan","Feb","Mar","Apr","May"]
[null,"John",772,685,481,505,507]
[null,"Roman",437,312,470,741,722]
[null,"Finn",447,414,630,784,754]
[null,"Seth",760,661,745,675,654]
[null,"Dean",334,351,643,633,564]
[null,"Brock",304,615,320,546,432]
[null,"Edge",711,357,494,576,578]
[null,"Rock",318,592,591,437,382]
[null,"Paul",638,593,604,582,605]

{"sheet":"Columns Go Forever","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Deleting Columns That Go on Forever"]
[]
[null,"Name/Sales","Jan","Feb"]
[null,"John",772,685]
[null,"Roman",437,312]
[null,"Finn",447,414]
[null,"Seth",760,661]
[null,"Dean",334,351]
[null,"Brock",304,615]
[null,"Edge",711,702]
[null,"Rock",318,592]
[null,"Paul",638,593]

{"sheet":"Using Formula","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9],[3,1,4,1],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9]]}
[]
[null,"Using Formula to Remove Blank Columns"]
[]
[null,"Name/Sales",2020,null,2021,null,2022,null,2023]
[null,null,"Jan","Feb","Jan","Feb","Jan","Feb","Jan","Feb"]
[null,"John",772,685,505,507,440,510,336,218]
[null,"Roman",437,312,741,722,361,null,null,298]
[null,"Finn",447,414,784,754,373,573,341,335]
[null,"Seth",760,661,675,654,775,619,158,371]
[null,"Dean",334,351,633,564,569,null,null,452]
[null,"Brock",304,615,546,432,763,746,336,313]
[null,"Edge",711,702,494,null,515,610,null,200]
[null,"Rock",318,592,437,382,605,null,414,396]
[null,"Paul",638,593,582,605,656,789,351,321]

{"sheet":"Columns Having Certain Text","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[1,1,1,9],[3,1,4,1]]}
[]
[null,"Using VBA to Delete Columns Having Certain Text"]
[]
[null,"Name/Sales",2020,null,2021,null,2022,null,2023]
[null,null,"Jan","Feb","Jan","Feb","Jan","Feb","Jan","Feb"]
[null,"John",772,685,505,507,440,510,336,218]
[null,"Roman",437,312,741,722,361,704,472,298]
[null,"Finn",447,414,784,754,373,573,341,335]
[null,"Seth",760,661,675,654,775,619,158,371]
[null,"Dean",334,351,633,564,569,610,392,452]
[null,"Brock",304,615,546,432,763,746,336,313]
[null,"Edge",711,702,494,576,515,610,119,200]
[null,"Rock",318,592,437,382,605,431,414,396]
[null,"Paul",638,593,582,605,656,789,351,321]

{"sheet":"Columns Having No Data","index":5,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,4,1],[3,2,3,3],[3,5,3,6],[3,7,3,8]]}
[]
[null,"Use of Go To Special to Delete the Columns Having no Data"]
[]
[null,"Name/Sales",2020,null,2021,2022]
[null,null,"Jan","Feb","Jan","Jan","Mar","Feb","Mar"]
[null,"John",772,685,505,440,576,218,141]
[null,"Roman",437,312,741,361,468,298,130]
[null,"Finn",447,414,784,373,339,335,316]
[null,"Seth",760,661,675,775,347,371,429]
[null,"Dean",334,351,633,569,745,452,414]
[null,"Brock",304,615,546,763,786,313,463]
[null,"Edge",711,702,494,515,637,200,337]
[null,"Rock",318,592,437,605,532,396,161]
[null,"Paul",638,593,582,656,742,321,170]

{"sheet":"Power Query with edit","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Jan","Name/Sales","Feb","Mar"]
[772,"John",685,481]
[437,"Roman",312,470]
[447,"Finn",414,630]
[760,"Seth",661,745]
[334,"Dean",351,643]
[304,"Brock",615,320]
[711,"Edge",702,357]
[318,"Rock",592,591]
[638,"Paul",593,604]

{"sheet":"Power Query","index":7,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,11]]}
[]
[null,"Sample Dataset"]
[]
[null,"Name/Sales","Jan","Feb","Mar","Apr","May","Column1","Jun","Jul","Aug","Sep"]
[null,"John",772,685,481,505,507,null,691,440,510,576]
[null,"Roman",437,312,470,741,722,null,448,361,704,468]
[null,"Finn",447,414,630,784,754,null,543,373,573,339]
[null,"Seth",760,661,745,675,654,null,501,775,619,347]
[null,"Dean",334,351,643,633,564,null,520,569,610,745]
[null,"Brock",304,615,320,546,432,null,629,763,746,786]
[null,"Edge",711,702,357,494,576,null,578,515,610,637]
[null,"Rock",318,592,591,437,382,null,659,605,431,532]
[null,"Paul",638,593,604,582,605,null,355,656,789,742]

{"sheet":"Deleting Cells","index":8,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Deleting Cells"]
[]
[null,"Name/Sales","Jan","Feb","Mar","Apr","Sep"]
[null,"John",772,685,481,505,576]
[null,"Roman",437,312,470,741,468]
[null,"Finn",447,414,630,784,339]
[null,"Seth",760,661,745,675,347]
[null,"Dean",334,351,643,633,745]
[null,"Brock",304,615,320,546,786]
[null,"Edge",711,357,494,576]
[null,"Rock",318,592,591,437,532]
[null,"Paul",638,593,604,582,742]