{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["лист"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"лист","index":0,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,4],[1,7,1,9],[1,11,1,13]]}
[]
["Таблица основная",null,null,null,null,null,null,"Таблица 1",null,null,null,"Таблица  2"]
["номер","адрес/название","время","сумма","курьер","курьер 1",null,"п/н","Адресс","Сумма",null,"п/н","Адресс","Сумма"]
[1,"ул Первая",null,1,"курьер 1",null,null,1,{"$f":"IF(E4=$F$3,B4,\"\")","v":"ул Первая"},{"$f":"IF(E4=$F$3,D4,\"\")","v":1},null,1]
[2,"ул Вторая",null,2,null,null,null,2,"","",null,2]
[3,"ул Первая",null,3,null,null,null,3,"","",null,3]
[4,"ул Первая",null,4,"курьер 1",null,null,4,"ул Первая",4,null,4]
[5,"ул Третья",null,5,"курьер 1",null,null,5,"ул Третья",5,null,5]
[6,"ул Пятая",null,6,null,null,null,6,"","",null,6]
[7,"ул Вторая",null,7,"курьер 1",null,null,7,"ул Вторая",7,null,7]
[8,"ул Первая",null,8,null,null,null,8,"","",null,8]
[9,"ул Первая",null,9,"курьер 1",null,null,9,"ул Первая",9,null,9]
[10,null,null,null,null,null,null,10,"","",null,10]
[11,null,null,null,null,null,null,11,"","",null,11]
[12,null,null,null,null,null,null,12,"","",null,12]
[13,null,null,null,null,null,null,13,"","",null,13]
[14,null,null,null,null,null,null,14,"","",null,14]
[15,null,null,null,null,null,null,15,"","",null,15]
[16,null,null,null,null,null,null,16,"","",null,16]
[17,null,null,null,null,null,null,17,"","",null,17]
[18,"ул Первая",null,10,"курьер 1",null,null,18,"ул Первая",10,null,18]
[19,null,null,null,null,null,null,19,"","",null,19]
[20,null,null,null,null,null,null,20,"","",null,20]
[]
[null,null,null,null,null,null,null,null,null,10,null,null,null,14]
[]
[null,null,null,null,null,"Нужно чтобы из Таблицы 1 данные автоматически заполнялись в Таблице 2, но без промежуточных пустых строк?"]