{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,3,16,11]]}
[]
[]
[]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B4))),\"\")","v":10}]
[10,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B5))),\"\")","v":12}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B6))),\"\")","v":25},null,"أريد كود أو دالة لنقل البيانات من العمود A الى العمود B مرتبة\nلكن بشرط تجاهل الخلايا الفارغة"]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B7))),\"\")","v":40}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B8))),\"\")","v":""}]
[12,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B9))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B10))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B11))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B12))),\"\")","v":""}]
[25,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B13))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B14))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B15))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B16))),\"\")","v":""}]
[40,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B17))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B18))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(A$4:A$1000,SMALL(IF(A$4:A$1000<>\"\",ROW(A$4:A$1000)-ROW(A$4)+1),ROWS(B$4:B19))),\"\")","v":""}]