{"id":38861,"date":"2026-10-22T13:49:36","date_gmt":"2026-10-22T12:49:36","guid":{"rendered":"https:\/\/keyfy.com\/blog\/%cf%80%cf%8e%cf%82-%ce%bd%ce%b1-%cf%83%cf%85%ce%bd%ce%b4%cf%85%ce%ac%cf%83%ce%b5%cf%84%ce%b5-%ce%b4%ce%b5%ce%b4%ce%bf%ce%bc%ce%ad%ce%bd%ce%b1-%ce%b1%cf%80%cf%8c-%ce%b4%cf%8d%ce%bf-%cf%86%cf%8d%ce%bb\/"},"modified":"2026-10-22T13:49:36","modified_gmt":"2026-10-22T12:49:36","slug":"%cf%80%cf%8e%cf%82-%ce%bd%ce%b1-%cf%83%cf%85%ce%bd%ce%b4%cf%85%ce%ac%cf%83%ce%b5%cf%84%ce%b5-%ce%b4%ce%b5%ce%b4%ce%bf%ce%bc%ce%ad%ce%bd%ce%b1-%ce%b1%cf%80%cf%8c-%ce%b4%cf%8d%ce%bf-%cf%86%cf%8d%ce%bb","status":"publish","type":"post","link":"https:\/\/keyfy.com\/el\/blog\/%cf%80%cf%8e%cf%82-%ce%bd%ce%b1-%cf%83%cf%85%ce%bd%ce%b4%cf%85%ce%ac%cf%83%ce%b5%cf%84%ce%b5-%ce%b4%ce%b5%ce%b4%ce%bf%ce%bc%ce%ad%ce%bd%ce%b1-%ce%b1%cf%80%cf%8c-%ce%b4%cf%8d%ce%bf-%cf%86%cf%8d%ce%bb\/","title":{"rendered":"\u03a0\u03ce\u03c2 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03c5\u03ac\u03c3\u03b5\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c4\u03bf\u03c5 Excel"},"content":{"rendered":"<p>\u039c\u03b9\u03b1 \u0394\u03b5\u03c5\u03c4\u03ad\u03c1\u03b1, \u03bb\u03b1\u03bc\u03b2\u03ac\u03bd\u03b5\u03c4\u03b5 \u03b4\u03cd\u03bf \u03b1\u03c1\u03c7\u03b5\u03af\u03b1 \u03c3\u03c4\u03bf inbox \u03c3\u03b1\u03c2. \u03a4\u03bf \u03ad\u03bd\u03b1 \u03b1\u03c6\u03bf\u03c1\u03ac \u03c4\u03b9\u03c2 \u03c0\u03b1\u03c1\u03b1\u03b3\u03b3\u03b5\u03bb\u03af\u03b5\u03c2 \u03c4\u03bf\u03c5 \u03c0\u03b5\u03c1\u03b1\u03c3\u03bc\u03ad\u03bd\u03bf\u03c5 \u03bc\u03ae\u03bd\u03b1, \u03c4\u03bf \u03ac\u03bb\u03bb\u03bf \u03b1\u03c5\u03c4\u03ad\u03c2 \u03c4\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03bf\u03bd\u03c4\u03bf\u03c2 \u03bc\u03ae\u03bd\u03b1, \u03ba\u03b1\u03b9 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03c2 \u03b1\u03c0\u03cc \u03c4\u03b1 \u03b1\u03bd\u03ce\u03c4\u03b5\u03c1\u03b1 \u03c3\u03c4\u03b5\u03bb\u03ad\u03c7\u03b7 \u03b8\u03ad\u03bb\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03b5\u03bd\u03b9\u03b1\u03af\u03b1 \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ac \u03bc\u03ad\u03c7\u03c1\u03b9 \u03c4\u03bf \u03bc\u03b5\u03c3\u03b7\u03bc\u03ad\u03c1\u03b9. \u0391\u03bd\u03bf\u03af\u03b3\u03b5\u03c4\u03b5 \u03bb\u03bf\u03b9\u03c0\u03cc\u03bd \u03ba\u03b1\u03b9 \u03c4\u03b1 \u03b4\u03cd\u03bf, \u03b1\u03c1\u03c7\u03af\u03b6\u03b5\u03c4\u03b5 \u03bd\u03b1 \u03b1\u03bd\u03c4\u03b9\u03b3\u03c1\u03ac\u03c6\u03b5\u03c4\u03b5 \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03b5\u03c0\u03b9\u03ba\u03bf\u03bb\u03bb\u03ac\u03c4\u03b5, \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03bc\u03b9\u03c3\u03ac \u03c4\u03b7\u03c2 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1\u03c2 \u03c3\u03c5\u03bd\u03b5\u03b9\u03b4\u03b7\u03c4\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03cc\u03c4\u03b9 \u03bf\u03b9 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03b4\u03b5\u03bd \u03b5\u03c5\u03b8\u03c5\u03b3\u03c1\u03b1\u03bc\u03bc\u03af\u03b6\u03bf\u03bd\u03c4\u03b1\u03b9 \u03ba\u03b1\u03bd \u03bc\u03b5 \u03c4\u03bf\u03bd \u03af\u03b4\u03b9\u03bf \u03c4\u03c1\u03cc\u03c0\u03bf. \u03a3\u03b1\u03c2 \u03b1\u03ba\u03bf\u03cd\u03b3\u03b5\u03c4\u03b1\u03b9 \u03bf\u03b9\u03ba\u03b5\u03af\u03bf;<\/p>\n<p>\u0391\u03c5\u03c4\u03cc \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03c3\u03b7\u03bc\u03b5\u03af\u03bf \u03c0\u03bf\u03c5 \u03c3\u03c7\u03b5\u03b4\u03cc\u03bd \u03ba\u03b1\u03bd\u03b5\u03af\u03c2 \u03b4\u03b5\u03bd \u03b1\u03bd\u03b1\u03c6\u03ad\u03c1\u03b5\u03b9 \u03b5\u03be \u03b1\u03c1\u03c7\u03ae\u03c2. \u03a5\u03c0\u03ac\u03c1\u03c7\u03bf\u03c5\u03bd \u03b4\u03cd\u03bf \u03b5\u03bd\u03c4\u03b5\u03bb\u03ce\u03c2 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ad\u03c2 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b5\u03c2 \u03c0\u03bf\u03c5 \u03ba\u03c1\u03cd\u03b2\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c0\u03af\u03c3\u03c9 \u03b1\u03c0\u03cc \u03c4\u03b7 \u03c6\u03c1\u03ac\u03c3\u03b7<strong>\u00ab\u03c3\u03c5\u03bd\u03b4\u03c5\u03b1\u03c3\u03bc\u03cc\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03b1\u03c0\u03cc \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c3\u03c4\u03bf Excel<\/strong>\u00bb, \u03ba\u03b1\u03b9 \u03b1\u03bd \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03b5\u03b9\u03c2 \u03c4\u03b7 \u03bb\u03ac\u03b8\u03bf\u03c2 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1, \u03b8\u03b1 \u03c7\u03ac\u03c3\u03b5\u03b9\u03c2 \u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc\u03b3\u03b5\u03c5\u03bc\u03b1. \u0397 \u03bc\u03af\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03c3\u03c4\u03bf\u03b9\u03b2\u03ac\u03b6\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03b7 \u03bc\u03af\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b7\u03bd \u03ac\u03bb\u03bb\u03b7. \u0397 \u03ac\u03bb\u03bb\u03b7 \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03b6\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03b7 \u03bc\u03af\u03b1 \u03b4\u03af\u03c0\u03bb\u03b1 \u03c3\u03c4\u03b7\u03bd \u03ac\u03bb\u03bb\u03b7 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ce\u03bd\u03c4\u03b1\u03c2 \u03ad\u03bd\u03b1 \u03ba\u03bf\u03b9\u03bd\u03cc \u03b1\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03cc. \u0391\u03bd \u03b4\u03b9\u03b1\u03b3\u03bd\u03ce\u03c3\u03b5\u03b9\u03c2 \u03c3\u03c9\u03c3\u03c4\u03ac \u03c4\u03bf \u03c0\u03c1\u03cc\u03b2\u03bb\u03b7\u03bc\u03b1, \u03b7 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ae \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b4\u03b9\u03b1\u03c1\u03ba\u03b5\u03af \u03bb\u03af\u03b3\u03b1 \u03bb\u03b5\u03c0\u03c4\u03ac.<\/p>\n<p>\u03a4\u03bf \u03b8\u03ad\u03bc\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03cc\u03c4\u03b9 \u03b1\u03c5\u03c4\u03cc\u03c2 \u03bf \u03bf\u03b4\u03b7\u03b3\u03cc\u03c2 \u03ba\u03b1\u03c4\u03b1\u03c4\u03ac\u03c3\u03c3\u03b5\u03b9 \u03c0\u03c1\u03ce\u03c4\u03b1 \u03c4\u03b9\u03c2 \u03c0\u03b5\u03c1\u03b9\u03c0\u03c4\u03ce\u03c3\u03b5\u03b9\u03c2 \u03b1\u03bd\u03ac\u03bb\u03bf\u03b3\u03b1 \u03bc\u03b5 \u03c4\u03bf\u03bd \u03c3\u03ba\u03bf\u03c0\u03cc \u03ba\u03b1\u03b9, \u03c3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1, \u03c0\u03c1\u03bf\u03c4\u03b5\u03af\u03bd\u03b5\u03b9 \u03c4\u03bf \u03ba\u03b1\u03c4\u03ac\u03bb\u03bb\u03b7\u03bb\u03bf \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf \u03b3\u03b9\u03b1 \u03ba\u03ac\u03b8\u03b5 \u03bc\u03af\u03b1. \u03a7\u03c9\u03c1\u03af\u03c2 \u03b5\u03b9\u03ba\u03b1\u03c3\u03af\u03b5\u03c2.<\/p>\n<div class=\"pb-tldr\" style=\"background: #eef2ff; border-left: 4px solid #007aff; border-radius: 8px; padding: 16px 20px; margin: 24px 0;\">\n<div style=\"font-weight: bold; color: #4f46e5; font-size: 13px; letter-spacing: 1.5px; margin-bottom: 6px;\">\u03a3\u03cd\u03bd\u03c4\u03bf\u03bc\u03b7 \u03c0\u03b5\u03c1\u03af\u03bb\u03b7\u03c8\u03b7 (TLDR)<\/div>\n<div style=\"color: #1f2937;\">\u03a4\u03bf \u03b1\u03bd \u03b8\u03b1 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c3\u03b5\u03c4\u03b5 \u03ae \u03b8\u03b1 \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ae\u03c3\u03b5\u03c4\u03b5 \u03b5\u03be\u03b1\u03c1\u03c4\u03ac\u03c4\u03b1\u03b9 \u03b1\u03c0\u03cc \u03ad\u03bd\u03b1 \u03c0\u03c1\u03ac\u03b3\u03bc\u03b1: \u03c4\u03b1 \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c3\u03b1\u03c2 \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03bf\u03c5\u03bd \u03c4\u03bf\u03bd \u03af\u03b4\u03b9\u03bf \u03c4\u03cd\u03c0\u03bf \u03b5\u03b3\u03b3\u03c1\u03b1\u03c6\u03ce\u03bd (\u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c3\u03c4\u03b5 \u03c4\u03b9\u03c2) \u03ae \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ad\u03c2 \u03bb\u03b5\u03c0\u03c4\u03bf\u03bc\u03ad\u03c1\u03b5\u03b9\u03b5\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b9\u03c2 \u03af\u03b4\u03b9\u03b5\u03c2 \u03b5\u03b3\u03b3\u03c1\u03b1\u03c6\u03ad\u03c2 (\u03c4\u03b1\u03b9\u03c1\u03b9\u03ac\u03be\u03c4\u03b5 \u03c4\u03b9\u03c2); <strong>\u03a4\u03bf Power Query<\/strong> \u03c3\u03c4\u03bf\u03b9\u03b2\u03ac\u03b6\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03b7 \u03bc\u03af\u03b1 \u03ba\u03ac\u03c4\u03c9 \u03b1\u03c0\u03cc \u03c4\u03b7\u03bd \u03ac\u03bb\u03bb\u03b7. <strong>\u039f\u03b9 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 XLOOKUP<\/strong> \u03ae <strong>INDEX\/MATCH<\/strong> \u03b1\u03bd\u03c4\u03bb\u03bf\u03cd\u03bd \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03b1\u03c0\u03cc \u03b4\u03b9\u03ac\u03c6\u03bf\u03c1\u03b1 \u03c6\u03cd\u03bb\u03bb\u03b1 \u03bc\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03ad\u03bd\u03b1 \u03ba\u03bf\u03b9\u03bd\u03cc \u03ba\u03bb\u03b5\u03b9\u03b4\u03af. \u0391\u03bd\u03b1\u03bb\u03cd\u03c3\u03c4\u03b5 \u03c4\u03bf \u03c0\u03c1\u03cc\u03b2\u03bb\u03b7\u03bc\u03b1 \u03c0\u03c1\u03b9\u03bd \u03b1\u03b3\u03b3\u03af\u03be\u03b5\u03c4\u03b5 \u03bf\u03c0\u03bf\u03b9\u03bf\u03bd\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03c4\u03cd\u03c0\u03bf.<\/div>\n<\/div>\n<h2>\u03a0\u03ce\u03c2 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03c5\u03ac\u03c3\u03b5\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c3\u03c4\u03bf Excel: \u03a4\u03bf \u03bb\u03ac\u03b8\u03bf\u03c2 \u03c0\u03bf\u03c5 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bd \u03cc\u03bb\u03bf\u03b9 \u03c0\u03c1\u03ce\u03c4\u03b1<\/h2>\n<p>\u039f\u03b9 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03bf\u03b9 \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03b5\u03c0\u03b9\u03bb\u03ad\u03b3\u03bf\u03c5\u03bd \u03bc\u03b9\u03b1 \u03bc\u03ad\u03b8\u03bf\u03b4\u03bf \u03ba\u03b1\u03b9 \u03b5\u03c0\u03b9\u03ba\u03b5\u03bd\u03c4\u03c1\u03ce\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03b1\u03c0\u03bf\u03ba\u03bb\u03b5\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03c3\u03b5 \u03b1\u03c5\u03c4\u03ae\u03bd. \u0395\u03be\u03b7\u03b3\u03bf\u03cd\u03bd \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 VLOOKUP \u03c3\u03b5 \u03ad\u03be\u03b9 \u03c0\u03b1\u03c1\u03b1\u03b3\u03c1\u03ac\u03c6\u03bf\u03c5\u03c2 \u03ae \u03c0\u03b1\u03c1\u03bf\u03c5\u03c3\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd \u03c4\u03bf Power Query \u03c7\u03c9\u03c1\u03af\u03c2 \u03bd\u03b1 \u03b1\u03bd\u03b1\u03c6\u03ad\u03c1\u03bf\u03c5\u03bd \u03ba\u03b1\u03b8\u03cc\u03bb\u03bf\u03c5 \u03c4\u03b9\u03c2 \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2. \u039f\u03b9 \u03bc\u03b9\u03c3\u03bf\u03af \u03b1\u03bd\u03b1\u03b3\u03bd\u03ce\u03c3\u03c4\u03b5\u03c2 \u03ba\u03b1\u03c4\u03b1\u03bb\u03ae\u03b3\u03bf\u03c5\u03bd \u03c3\u03c4\u03b7 \u03bb\u03ac\u03b8\u03bf\u03c2 \u03c3\u03b5\u03bb\u03af\u03b4\u03b1 \u03ba\u03b1\u03b9 \u03c6\u03b5\u03cd\u03b3\u03bf\u03c5\u03bd \u03c0\u03b9\u03bf \u03bc\u03c0\u03b5\u03c1\u03b4\u03b5\u03bc\u03ad\u03bd\u03bf\u03b9 \u03b1\u03c0\u03cc \u03cc,\u03c4\u03b9 \u03cc\u03c4\u03b1\u03bd \u03bc\u03c0\u03ae\u03ba\u03b1\u03bd.<\/p>\n<p>\u03a4\u03bf \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc \u03c0\u03c1\u03cc\u03b2\u03bb\u03b7\u03bc\u03b1 \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf. \u0395\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03b3\u03b5\u03b3\u03bf\u03bd\u03cc\u03c2 \u03cc\u03c4\u03b9 \u03bf\u03b9 \u03ac\u03bd\u03b8\u03c1\u03c9\u03c0\u03bf\u03b9 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bd \u03b1\u03bd\u03c4\u03b9\u03b3\u03c1\u03b1\u03c6\u03ae-\u03b5\u03c0\u03b9\u03ba\u03cc\u03bb\u03bb\u03b7\u03c3\u03b7 \u03bc\u03b5 \u03c4\u03bf \u03c7\u03ad\u03c1\u03b9, \u03b5\u03c0\u03b5\u03b9\u03b4\u03ae \u03b4\u03b5\u03bd \u03c3\u03c4\u03b1\u03bc\u03ac\u03c4\u03b7\u03c3\u03b1\u03bd \u03c0\u03bf\u03c4\u03ad \u03bd\u03b1 \u03b1\u03bd\u03b1\u03c1\u03c9\u03c4\u03b7\u03b8\u03bf\u03cd\u03bd \u03c3\u03b5 \u03c0\u03bf\u03b9\u03b1 \u03bc\u03bf\u03c1\u03c6\u03ae \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1. \u039a\u03b1\u03b9 \u03b7 \u03c7\u03b5\u03b9\u03c1\u03bf\u03ba\u03af\u03bd\u03b7\u03c4\u03b7 \u03b5\u03c0\u03b9\u03ba\u03cc\u03bb\u03bb\u03b7\u03c3\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03b5\u03af \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1\u03c4\u03b1 \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b5\u03cd\u03ba\u03bf\u03bb\u03bf \u03bd\u03b1 \u03c0\u03b5\u03c1\u03ac\u03c3\u03bf\u03c5\u03bd \u03b1\u03c0\u03b1\u03c1\u03b1\u03c4\u03ae\u03c1\u03b7\u03c4\u03b1 \u2014 \u03bc\u03b9\u03b1 \u03c4\u03c5\u03c7\u03b1\u03af\u03b1 \u03ba\u03b5\u03bd\u03ae \u03c3\u03b5\u03b9\u03c1\u03ac \u03b5\u03b4\u03ce, \u03bc\u03b9\u03b1 \u03c3\u03c4\u03ae\u03bb\u03b7 \u03c0\u03bf\u03c5 \u03ad\u03c7\u03b5\u03b9 \u03bc\u03b5\u03c4\u03b1\u03c4\u03bf\u03c0\u03b9\u03c3\u03c4\u03b5\u03af \u03ba\u03b1\u03c4\u03ac \u03bc\u03af\u03b1 \u03b8\u03ad\u03c3\u03b7 \u03b5\u03ba\u03b5\u03af, \u03ba\u03b1\u03b9 \u03be\u03b1\u03c6\u03bd\u03b9\u03ba\u03ac \u03c4\u03bf \u03c3\u03cd\u03bd\u03bf\u03bb\u03bf \u03c3\u03bf\u03c5 \u03ad\u03c7\u03b5\u03b9 \u03b1\u03c0\u03cc\u03ba\u03bb\u03b9\u03c3\u03b7 \u03bc\u03b5\u03c1\u03b9\u03ba\u03ce\u03bd \u03c7\u03b9\u03bb\u03b9\u03ac\u03b4\u03c9\u03bd \u03ba\u03b1\u03b9 \u03ba\u03b1\u03bd\u03b5\u03af\u03c2 \u03b4\u03b5\u03bd \u03be\u03ad\u03c1\u03b5\u03b9 \u03b3\u03b9\u03b1\u03c4\u03af.<\/p>\n<p>\u03a0\u03c1\u03b9\u03bd \u03b1\u03c0\u03cc \u03bf\u03c4\u03b9\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03ac\u03bb\u03bb\u03bf, \u03ba\u03ac\u03bd\u03c4\u03b5 \u03bb\u03bf\u03b9\u03c0\u03cc\u03bd \u03b1\u03c5\u03c4\u03cc\u03bd \u03c4\u03bf\u03bd \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03bf \u03ad\u03bb\u03b5\u03b3\u03c7\u03bf.<\/p>\n<ul>\n<li>\u0394\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1, \u03af\u03b4\u03b9\u03b5\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2, \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ad\u03c2 \u03b5\u03b3\u03b3\u03c1\u03b1\u03c6\u03ad\u03c2 (\u03c0\u03b1\u03c1\u03b1\u03b3\u03b3\u03b5\u03bb\u03af\u03b5\u03c2 \u0399\u03b1\u03bd\u03bf\u03c5\u03b1\u03c1\u03af\u03bf\u03c5 + \u03c0\u03b1\u03c1\u03b1\u03b3\u03b3\u03b5\u03bb\u03af\u03b5\u03c2 \u03a6\u03b5\u03b2\u03c1\u03bf\u03c5\u03b1\u03c1\u03af\u03bf\u03c5); \u03a0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 <strong>\u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c3\u03b5\u03c4\u03b5<\/strong> \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2. \u0391\u03c5\u03c4\u03ae \u03b5\u03af\u03bd\u03b1\u03b9 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03b3\u03b9\u03b1 \u03c4\u03bf Power Query.<\/li>\n<li>\u0394\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1, \u03ba\u03bf\u03b9\u03bd\u03ae \u03c3\u03c4\u03ae\u03bb\u03b7 ID, \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ad\u03c2 \u03bb\u03b5\u03c0\u03c4\u03bf\u03bc\u03ad\u03c1\u03b5\u03b9\u03b5\u03c2 (ID \u03c0\u03b1\u03c1\u03b1\u03b3\u03b3\u03b5\u03bb\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf \u03ad\u03bd\u03b1, email \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd \u03c3\u03c4\u03bf \u03ac\u03bb\u03bb\u03bf); \u03a0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 <strong>\u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03c3\u03b5\u03c4\u03b5<\/strong> \u03c4\u03b9\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2. \u0391\u03c5\u03c4\u03ae \u03b5\u03af\u03bd\u03b1\u03b9 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03b3\u03b9\u03b1 \u03c4\u03b9\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 XLOOKUP \u03ae INDEX\/MATCH.<\/li>\n<\/ul>\n<p>\u0391\u03c5\u03c4\u03ae \u03b7 \u03bc\u03af\u03b1 \u03b5\u03c1\u03ce\u03c4\u03b7\u03c3\u03b7 \u03ba\u03b1\u03b8\u03bf\u03c1\u03af\u03b6\u03b5\u03b9 \u03cc\u03bb\u03b1 \u03cc\u03c3\u03b1 \u03b1\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03bf\u03cd\u03bd. \u0391\u03bd \u03b1\u03c0\u03b1\u03bd\u03c4\u03ae\u03c3\u03b5\u03c4\u03b5 \u03bb\u03ac\u03b8\u03bf\u03c2, \u03bf\u03cd\u03c4\u03b5 \u03b7 \u03bc\u03b5\u03b3\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03b7 \u03b4\u03b5\u03be\u03b9\u03cc\u03c4\u03b7\u03c4\u03b1 \u03c3\u03c4\u03b9\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03bd \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03c3\u03ce\u03c3\u03b5\u03b9.<\/p>\n<h2>\u03a0\u03c1\u03ce\u03c4\u03b7 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1: \u03a0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7 \u03c3\u03b5\u03b9\u03c1\u03ce\u03bd \u03bc\u03b5 \u03c4\u03bf Power Query<\/h2>\n<p>\u038c\u03c4\u03b1\u03bd \u03b8\u03ad\u03bb\u03b5\u03c4\u03b5 \u03bd\u03b1 <strong>\u03c3\u03c5\u03b3\u03c7\u03c9\u03bd\u03b5\u03cd\u03c3\u03b5\u03c4\u03b5 \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c4\u03bf\u03c5 Excel<\/strong> \u03c4\u03bf\u03c0\u03bf\u03b8\u03b5\u03c4\u03ce\u03bd\u03c4\u03b1\u03c2 \u03c4\u03bf \u03ad\u03bd\u03b1 \u03ba\u03ac\u03c4\u03c9 \u03b1\u03c0\u03cc \u03c4\u03bf \u03ac\u03bb\u03bb\u03bf, \u03c4\u03bf Power Query \u03b5\u03af\u03bd\u03b1\u03b9 \u03b7 \u03c0\u03b9\u03bf \u03b1\u03c0\u03bb\u03ae \u03bb\u03cd\u03c3\u03b7. \u0395\u03af\u03bd\u03b1\u03b9 \u03b5\u03bd\u03c3\u03c9\u03bc\u03b1\u03c4\u03c9\u03bc\u03ad\u03bd\u03bf \u03c3\u03c4\u03bf Excel (\u03ba\u03b1\u03c1\u03c4\u03ad\u03bb\u03b1 \u00ab\u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1\u00bb, \u03b1\u03c0\u03cc \u03c4\u03bf Excel 2016 \u03ba\u03b1\u03b9 \u03bc\u03b5\u03c4\u03ac) \u03ba\u03b1\u03b9 \u03b1\u03bd\u03b1\u03bd\u03b5\u03ce\u03bd\u03b5\u03c4\u03b1\u03b9, \u03bf\u03c0\u03cc\u03c4\u03b5 \u03c4\u03bf\u03bd \u03b5\u03c0\u03cc\u03bc\u03b5\u03bd\u03bf \u03bc\u03ae\u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03b9\u03c3\u03ac\u03b3\u03b5\u03c4\u03b5 \u03bd\u03ad\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03ba\u03bb\u03b9\u03ba \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03bf\u03c5\u03bc\u03c0\u03af \u03b1\u03bd\u03c4\u03af \u03bd\u03b1 \u03be\u03b1\u03bd\u03b1\u03c6\u03c4\u03b9\u03ac\u03be\u03b5\u03c4\u03b5 \u03bf\u03bb\u03cc\u03ba\u03bb\u03b7\u03c1\u03bf \u03c4\u03bf \u03ad\u03c1\u03b3\u03bf.<\/p>\n<p>\u0397 \u03af\u03b4\u03b9\u03b1 \u03b7 \u03c4\u03b5\u03ba\u03bc\u03b7\u03c1\u03af\u03c9\u03c3\u03b7 \u03c4\u03b7\u03c2 Microsoft \u03ba\u03b1\u03bb\u03cd\u03c0\u03c4\u03b5\u03b9 \u03c4\u03b1 \u03b2\u03b1\u03c3\u03b9\u03ba\u03ac \u03b3\u03b9\u03b1 \u03c4\u03bf \u03c0\u03ce\u03c2 \u03bd\u03b1 <a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/combine-data-from-multiple-sheets\" rel=\"nofollow noopener\" target=\"_blank\">\u03c3\u03c5\u03bd\u03b4\u03c5\u03ac\u03c3\u03b5\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c0\u03bf\u03bb\u03bb\u03ac \u03c6\u03cd\u03bb\u03bb\u03b1<\/a>, \u03b1\u03bb\u03bb\u03ac \u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7\u03c2 \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03b1 \u03c9\u03c2 \u03b5\u03be\u03ae\u03c2.<\/p>\n<p>\u039c\u03b5\u03c4\u03b1\u03c4\u03c1\u03ad\u03c8\u03c4\u03b5 \u03c0\u03c1\u03ce\u03c4\u03b1 \u03ba\u03ac\u03b8\u03b5 \u03c6\u03cd\u03bb\u03bb\u03bf \u03c3\u03b5 \u03ba\u03b1\u03bd\u03bf\u03bd\u03b9\u03ba\u03cc \u03c0\u03af\u03bd\u03b1\u03ba\u03b1. \u039a\u03ac\u03bd\u03c4\u03b5 \u03ba\u03bb\u03b9\u03ba \u03bf\u03c0\u03bf\u03c5\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b1\u03c2, \u03c0\u03b1\u03c4\u03ae\u03c3\u03c4\u03b5 Ctrl+T \u03ba\u03b1\u03b9 \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03c4\u03b5 \u03c4\u03bf \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u00ab\u039a\u03b5\u03c6\u03b1\u03bb\u03af\u03b4\u03b5\u03c2\u00bb. \u039a\u03ac\u03bd\u03c4\u03b5 \u03c4\u03bf \u03af\u03b4\u03b9\u03bf \u03ba\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03c4\u03b1 \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1. \u039f\u03bd\u03bf\u03bc\u03ac\u03c3\u03c4\u03b5 \u03c4\u03b1 \u03bc\u03b5 \u03ba\u03ac\u03c4\u03b9 \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03b1\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5, \u03cc\u03c0\u03c9\u03c2 \u00ab <code>tblJan<\/code> \u00bb \u03ba\u03b1\u03b9 \u00ab <code>tblFeb<\/code> \u00bb, \u03c3\u03c4\u03b7\u03bd \u03b5\u03bd\u03cc\u03c4\u03b7\u03c4\u03b1 \u00ab\u03a3\u03c7\u03b5\u03b4\u03b9\u03b1\u03c3\u03bc\u03cc\u03c2 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1\u00bb.<\/p>\n<p>\u03a3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1, \u03c6\u03bf\u03c1\u03c4\u03ce\u03c3\u03c4\u03b5 \u03c4\u03bf \u03ba\u03b1\u03b8\u03ad\u03bd\u03b1 \u03c3\u03c4\u03bf Power Query. \u039c\u03b5 \u03c4\u03bf\u03bd \u03ba\u03ad\u03c1\u03c3\u03bf\u03c1\u03b1 \u03c3\u03c4\u03bf\u03bd \u03c0\u03c1\u03ce\u03c4\u03bf \u03c0\u03af\u03bd\u03b1\u03ba\u03b1, \u03bc\u03b5\u03c4\u03b1\u03b2\u03b5\u03af\u03c4\u03b5 \u03c3\u03c4\u03b7\u03bd \u03b5\u03bd\u03cc\u03c4\u03b7\u03c4\u03b1 \u00ab\u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1\u00bb  &gt;  \u0391\u03c0\u03cc \u00ab\u03a0\u03af\u03bd\u03b1\u03ba\u03b1\u03c2\/\u0395\u03cd\u03c1\u03bf\u03c2\u00bb. \u0391\u03bd\u03bf\u03af\u03b3\u03b5\u03b9 \u03c4\u03bf \u03c0\u03c1\u03cc\u03b3\u03c1\u03b1\u03bc\u03bc\u03b1 \u03b5\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2. \u0394\u03b5\u03bd \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03b1\u03bb\u03bb\u03ac\u03be\u03b5\u03c4\u03b5 \u03c4\u03af\u03c0\u03bf\u03c4\u03b1 \u03b5\u03b4\u03ce \u2014 \u03b1\u03c0\u03bb\u03ce\u03c2 \u03ba\u03bb\u03b5\u03af\u03c3\u03c4\u03b5 \u03c4\u03bf \u03ba\u03b1\u03b9 \u03c6\u03bf\u03c1\u03c4\u03ce\u03c3\u03c4\u03b5 \u03c4\u03bf \u03bc\u03cc\u03bd\u03bf \u03c9\u03c2 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 (\u0391\u03c1\u03c7\u03b5\u03af\u03bf  &gt;  \u039a\u03bb\u03b5\u03af\u03c3\u03b9\u03bc\u03bf &#038; \u03a6\u03cc\u03c1\u03c4\u03c9\u03c3\u03b7 \u03c3\u03b5  &gt;  \u039c\u03cc\u03bd\u03bf \u00ab\u0394\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7\u03c2\u00bb). \u0395\u03c0\u03b1\u03bd\u03b1\u03bb\u03ac\u03b2\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03b3\u03b9\u03b1 \u03c4\u03bf\u03bd \u03b4\u03b5\u03cd\u03c4\u03b5\u03c1\u03bf \u03c0\u03af\u03bd\u03b1\u03ba\u03b1.<\/p>\n<p>\u03a4\u03ce\u03c1\u03b1 \u03b7 \u03af\u03b4\u03b9\u03b1 \u03b7 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7. \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 &gt; \u039b\u03ae\u03c8\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd &gt; \u03a3\u03c5\u03bd\u03b4\u03c5\u03b1\u03c3\u03bc\u03cc\u03c2 \u03b5\u03c1\u03c9\u03c4\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd &gt; \u03a0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7. \u0395\u03c0\u03b9\u03bb\u03ad\u03be\u03c4\u03b5 \u03c4\u03b1 \u03b4\u03cd\u03bf \u03b5\u03c1\u03c9\u03c4\u03ae\u03bc\u03b1\u03c4\u03ac \u03c3\u03b1\u03c2 \u03ba\u03b1\u03b9 \u03ba\u03ac\u03bd\u03c4\u03b5 \u03ba\u03bb\u03b9\u03ba \u03c3\u03c4\u03bf \u00abOK\u00bb. \u03a4\u03bf Power Query \u03c4\u03bf\u03c0\u03bf\u03b8\u03b5\u03c4\u03b5\u03af \u03c4\u03b9\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03c4\u03bf\u03c5 \u03b4\u03b5\u03cd\u03c4\u03b5\u03c1\u03bf\u03c5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1 \u03b1\u03ba\u03c1\u03b9\u03b2\u03ce\u03c2 \u03ba\u03ac\u03c4\u03c9 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd \u03c0\u03c1\u03ce\u03c4\u03bf, \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03b6\u03bf\u03bd\u03c4\u03b1\u03c2 \u03c4\u03b9\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03bc\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03c4\u03bf \u03cc\u03bd\u03bf\u03bc\u03b1 \u03c4\u03b7\u03c2 \u03ba\u03b5\u03c6\u03b1\u03bb\u03af\u03b4\u03b1\u03c2.<\/p>\n<div class=\"pb-tipbox pb-tipbox-info\" style=\"background: #eff6ff; border-left: 4px solid #3b82f6; border-radius: 8px; padding: 14px 18px; margin: 24px 0;\">\n<div style=\"font-weight: bold; color: #1d4ed8; font-size: 13px; letter-spacing: 1px; margin-bottom: 5px;\">\u03a0\u039b\u0397\u03a1\u039f\u03a6\u039f\u03a1\u0399\u0395\u03a3<\/div>\n<div style=\"color: #1f2937;\">\u03a4\u03bf Power Query \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03b6\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03bc\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03c4\u03bf \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf \u03c4\u03c9\u03bd \u03b5\u03c0\u03b9\u03ba\u03b5\u03c6\u03b1\u03bb\u03af\u03b4\u03c9\u03bd \u03c4\u03bf\u03c5\u03c2, \u03cc\u03c7\u03b9 \u03c4\u03b7 \u03b8\u03ad\u03c3\u03b7 \u03c4\u03bf\u03c5\u03c2. \u0395\u03c0\u03bf\u03bc\u03ad\u03bd\u03c9\u03c2, \u03b1\u03bd \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03c6\u03cd\u03bb\u03bb\u03bf \u03b1\u03bd\u03b1\u03b3\u03c1\u03ac\u03c6\u03b5\u03c4\u03b1\u03b9 \u00abCustomer\u00bb \u03ba\u03b1\u03b9 \u03c3\u03c4\u03bf \u03ac\u03bb\u03bb\u03bf \u00abClient\u00bb, \u03b1\u03c5\u03c4\u03ad\u03c2 \u03b8\u03b1 \u03b3\u03af\u03bd\u03bf\u03c5\u03bd \u03b4\u03cd\u03bf \u03be\u03b5\u03c7\u03c9\u03c1\u03b9\u03c3\u03c4\u03ad\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03bc\u03b5 \u03bc\u03b9\u03c3\u03bf\u03ba\u03b5\u03bd\u03ad\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2. \u039c\u03b5\u03c4\u03bf\u03bd\u03bf\u03bc\u03ac\u03c3\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03b5\u03c0\u03b9\u03ba\u03b5\u03c6\u03b1\u03bb\u03af\u03b4\u03b5\u03c2 \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03c4\u03b1\u03b9\u03c1\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd \u03c0\u03c1\u03b9\u03bd \u03b1\u03c0\u03cc \u03c4\u03b7\u03bd \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7, \u03ba\u03b1\u03b9 \u03c4\u03bf \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1 \u03b8\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03ba\u03b1\u03b8\u03b1\u03c1\u03cc.<\/div>\n<\/div>\n<p>\u03a6\u03bf\u03c1\u03c4\u03ce\u03c3\u03c4\u03b5 \u03c4\u03bf \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1 \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03bd\u03ad\u03bf \u03c6\u03cd\u03bb\u03bb\u03bf. \u0388\u03c4\u03bf\u03b9\u03bc\u03bf. \u039a\u03b1\u03b9 \u03c4\u03bf \u03c9\u03c1\u03b1\u03af\u03bf \u03bc\u03b5 \u03c4\u03b7\u03bd \u03c0\u03c1\u03bf\u03c3\u03ad\u03b3\u03b3\u03b9\u03c3\u03b7 <strong>\u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03c4\u03bf Excel \u03bc\u03ad\u03c3\u03c9 \u03c4\u03bf\u03c5 Power Query<\/strong> \u03b5\u03af\u03bd\u03b1\u03b9 \u03b7 \u03b1\u03bd\u03b1\u03bd\u03ad\u03c9\u03c3\u03b7. \u03a4\u03b7\u03bd \u03b5\u03c0\u03cc\u03bc\u03b5\u03bd\u03b7 \u03c6\u03bf\u03c1\u03ac \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03bb\u03ac\u03b2\u03b5\u03c4\u03b5 \u03b5\u03bd\u03b7\u03bc\u03b5\u03c1\u03c9\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c1\u03c7\u03b5\u03af\u03b1, \u03b5\u03c0\u03b9\u03ba\u03bf\u03bb\u03bb\u03ae\u03c3\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03bd\u03ad\u03b5\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03c3\u03c4\u03bf\u03c5\u03c2 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 \u03c0\u03c1\u03bf\u03ad\u03bb\u03b5\u03c5\u03c3\u03b7\u03c2 \u03ba\u03b1\u03b9 \u03c0\u03b1\u03c4\u03ae\u03c3\u03c4\u03b5 \u00abData\u00bb (\u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1) &gt; \u00abRefresh All\u00bb (\u0391\u03bd\u03b1\u03bd\u03ad\u03c9\u03c3\u03b7 \u03cc\u03bb\u03c9\u03bd). \u039f \u03c3\u03c5\u03bd\u03b4\u03c5\u03b1\u03c3\u03bc\u03ad\u03bd\u03bf\u03c2 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1\u03c2 \u03b5\u03bd\u03b7\u03bc\u03b5\u03c1\u03ce\u03bd\u03b5\u03c4\u03b1\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1.<\/p>\n<blockquote class=\"pb-pullquote\" style=\"border: none; border-top: 2px solid #4f46e5; border-bottom: 2px solid #4f46e5; margin: 32px auto; padding: 20px 24px; font-size: 19px; font-style: italic; color: #374151; text-align: center;\"><p>\u00ab\u0397 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7 \u03b4\u03b5\u03bd \u03ad\u03c7\u03b5\u03b9 \u03ba\u03b1\u03bc\u03af\u03b1 \u03c3\u03c7\u03ad\u03c3\u03b7 \u03bc\u03b5 \u03c4\u03cd\u03c0\u03bf\u03c5\u03c2. \u03a0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03c4\u03bf \u03bd\u03b1 \u03c5\u03c0\u03bf\u03b4\u03b5\u03af\u03be\u03b5\u03b9\u03c2 \u03c3\u03c4\u03bf Excel \u03cc\u03c4\u03b9 \u03b1\u03c5\u03c4\u03ad\u03c2 \u03bf\u03b9 \u03b4\u03cd\u03bf \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf\u03c5 \u03af\u03b4\u03b9\u03bf\u03c5 \u03b5\u03af\u03b4\u03bf\u03c5\u03c2 \u03ba\u03b1\u03b9, \u03c3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1, \u03bd\u03b1 \u03c4\u03bf \u03b1\u03c6\u03ae\u03c3\u03b5\u03b9\u03c2 \u03bd\u03b1 \u03c4\u03b9\u03c2 \u03c3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03ce\u03bd\u03b5\u03b9 \u03b3\u03b9\u03b1 \u03c3\u03ad\u03bd\u03b1 \u03ba\u03ac\u03b8\u03b5 \u03bc\u03ae\u03bd\u03b1, \u03cc\u03c0\u03bf\u03c4\u03b5 \u03c4\u03bf \u03b6\u03b7\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2.\u00bb<\/p><\/blockquote>\n<p>\u03a5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03b1\u03bd\u03b1\u03bb\u03c5\u03c4\u03b9\u03ba\u03ae \u03c0\u03b5\u03c1\u03b9\u03b3\u03c1\u03b1\u03c6\u03ae \u03c4\u03b7\u03c2 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7\u03c2 \u03bc\u03b5 \u03c0\u03bf\u03bb\u03bb\u03ac \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c3\u03c4\u03bf\u03bd <a href=\"https:\/\/trumpexcel.com\/combine-multiple-worksheets\/\" rel=\"nofollow noopener\" target=\"_blank\">\u03bf\u03b4\u03b7\u03b3\u03cc \u03c4\u03bf\u03c5 Trump Excel \u03b3\u03b9\u03b1 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03bd\u03c9\u03c3\u03b7 \u03c6\u03cd\u03bb\u03bb\u03c9\u03bd \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2<\/a>, \u03b1\u03bd \u03ad\u03c7\u03b5\u03c4\u03b5 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b1 \u03b1\u03c0\u03cc \u03b4\u03cd\u03bf \u03b1\u03c1\u03c7\u03b5\u03af\u03b1 \u03bd\u03b1 \u03b5\u03bd\u03c3\u03c9\u03bc\u03b1\u03c4\u03ce\u03c3\u03b5\u03c4\u03b5. \u0397 \u03bb\u03bf\u03b3\u03b9\u03ba\u03ae \u03b5\u03af\u03bd\u03b1\u03b9 \u03b7 \u03af\u03b4\u03b9\u03b1, \u03b1\u03c0\u03bb\u03ce\u03c2 \u03c5\u03c0\u03ac\u03c1\u03c7\u03bf\u03c5\u03bd \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c3\u03c4\u03b7 \u03bb\u03af\u03c3\u03c4\u03b1 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7\u03c2.<\/p>\n<h2>\u0395\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 2: \u0391\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03af\u03c7\u03b9\u03c3\u03b7 \u03c3\u03c4\u03b7\u03bb\u03ce\u03bd \u03bc\u03b5 \u03c4\u03b9\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 XLOOKUP \u03ae INDEX\/MATCH<\/h2>\n<p>\u0391\u03c5\u03c4\u03ae \u03b7 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ae\u03c2 \u03c6\u03cd\u03c3\u03b7\u03c2. \u03a4\u03b1 \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c3\u03b1\u03c2 \u03c0\u03b5\u03c1\u03b9\u03b3\u03c1\u03ac\u03c6\u03bf\u03c5\u03bd \u03c4\u03b9\u03c2 \u03af\u03b4\u03b9\u03b5\u03c2 \u03b5\u03b3\u03b3\u03c1\u03b1\u03c6\u03ad\u03c2, \u03b1\u03bb\u03bb\u03ac \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03bf\u03c5\u03bd \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03c3\u03c7\u03b5\u03c4\u03b9\u03ba\u03ac \u03bc\u03b5 \u03b1\u03c5\u03c4\u03ad\u03c2. \u03a4\u03bf \u03c0\u03c1\u03ce\u03c4\u03bf \u03c6\u03cd\u03bb\u03bb\u03bf \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03b5\u03b9 \u03ba\u03c9\u03b4\u03b9\u03ba\u03bf\u03cd\u03c2 \u03c0\u03b1\u03c1\u03b1\u03b3\u03b3\u03b5\u03bb\u03b9\u03ce\u03bd \u03ba\u03b1\u03b9 \u03c0\u03bf\u03c3\u03ac. \u03a4\u03bf \u03b4\u03b5\u03cd\u03c4\u03b5\u03c1\u03bf \u03c6\u03cd\u03bb\u03bb\u03bf \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf\u03c5\u03c2 \u03af\u03b4\u03b9\u03bf\u03c5\u03c2 \u03ba\u03c9\u03b4\u03b9\u03ba\u03bf\u03cd\u03c2 \u03c0\u03b1\u03c1\u03b1\u03b3\u03b3\u03b5\u03bb\u03b9\u03ce\u03bd, \u03ba\u03b1\u03b8\u03ce\u03c2 \u03ba\u03b1\u03b9 \u03c4\u03bf email \u03ba\u03b1\u03b9 \u03c4\u03b7\u03bd \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7. \u0398\u03ad\u03bb\u03b5\u03c4\u03b5 \u03bd\u03b1 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03ae\u03c3\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1\u03bd \u03c0\u03af\u03bd\u03b1\u03ba\u03b1 \u03bc\u03b5 \u03cc\u03bb\u03b1 \u03c4\u03b1 \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03b1 \u03b1\u03c5\u03c4\u03ac \u03c4\u03bf \u03ad\u03bd\u03b1 \u03b4\u03af\u03c0\u03bb\u03b1 \u03c3\u03c4\u03bf \u03ac\u03bb\u03bb\u03bf.<\/p>\n<p>\u03a0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03bc\u03b9\u03b1 \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03cc\u03c0\u03bf\u03c5 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b1\u03b9 <strong>\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 VLOOKUP \u03bc\u03b5\u03c4\u03b1\u03be\u03cd \u03c6\u03cd\u03bb\u03bb\u03c9\u03bd<\/strong>, \u03bc\u03cc\u03bd\u03bf \u03c0\u03bf\u03c5 \u03b7 VLOOKUP \u03b5\u03af\u03bd\u03b1\u03b9 \u03bf \u03c0\u03b1\u03bb\u03b9\u03cc\u03c2, \u03b1\u03c3\u03c4\u03b1\u03b8\u03ae\u03c2 \u03c4\u03c1\u03cc\u03c0\u03bf\u03c2. \u0397 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 XLOOKUP \u03c4\u03b7\u03bd \u03ad\u03c7\u03b5\u03b9 \u03b1\u03bd\u03c4\u03b9\u03ba\u03b1\u03c4\u03b1\u03c3\u03c4\u03ae\u03c3\u03b5\u03b9 \u03b3\u03b9\u03b1 \u03cc\u03c3\u03bf\u03c5\u03c2 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bd \u03c4\u03bf Microsoft 365 \u03ae \u03c4\u03bf Excel 2021, \u03ba\u03b1\u03b9 \u03b1\u03be\u03af\u03b6\u03b5\u03b9 \u03bd\u03b1 \u03c4\u03b7 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03b1\u03bd\u03c4\u2019 \u03b1\u03c5\u03c4\u03ae\u03c2.<\/p>\n<p>\u0391\u03c2 \u03c5\u03c0\u03bf\u03b8\u03ad\u03c3\u03bf\u03c5\u03bc\u03b5 \u03cc\u03c4\u03b9 \u03bf \u03ba\u03cd\u03c1\u03b9\u03bf\u03c2 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1\u03c2 \u03c3\u03b1\u03c2 \u03b2\u03c1\u03af\u03c3\u03ba\u03b5\u03c4\u03b1\u03b9 \u03c3\u03c4\u03bf \u03a6\u03cd\u03bb\u03bb\u03bf1, \u03bc\u03b5 \u03c4\u03bf\u03c5\u03c2 \u03ba\u03c9\u03b4\u03b9\u03ba\u03bf\u03cd\u03c2 \u03c0\u03b1\u03c1\u03b1\u03b3\u03b3\u03b5\u03bb\u03b9\u03ce\u03bd \u03c3\u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u0391. \u03a4\u03b1 email \u03c0\u03bf\u03c5 \u03b8\u03ad\u03bb\u03b5\u03c4\u03b5 \u03b2\u03c1\u03af\u03c3\u03ba\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c3\u03c4\u03bf \u03a6\u03cd\u03bb\u03bb\u03bf2, \u03bc\u03b5 \u03c4\u03bf\u03c5\u03c2 \u03ba\u03c9\u03b4\u03b9\u03ba\u03bf\u03cd\u03c2 \u03c3\u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u0391 \u03ba\u03b1\u03b9 \u03c4\u03b1 email \u03c3\u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u0392. \u03a3\u03c4\u03bf \u03a6\u03cd\u03bb\u03bb\u03bf1, \u03c3\u03c4\u03bf \u03ba\u03b5\u03bb\u03af D2:<\/p>\n<pre><code class=\"excel language-excel\">=XLOOKUP(A2, Sheet2!A:A, Sheet2!B:B, \"Not found\")\n<\/code><\/pre>\n<p>\u0391\u03c5\u03c4\u03cc \u03c3\u03b7\u03bc\u03b1\u03af\u03bd\u03b5\u03b9: \u03c0\u03ac\u03c1\u03b5 \u03c4\u03bf \u03b1\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03cc \u03b1\u03c0\u03cc \u03c4\u03bf \u03ba\u03b5\u03bb\u03af A2, \u03b2\u03c1\u03b5\u03c2 \u03c4\u03bf \u03c3\u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u00abID\u00bb \u03c4\u03bf\u03c5 \u03a6\u03cd\u03bb\u03bb\u03bf\u03c52 \u03ba\u03b1\u03b9 \u03b5\u03c0\u03ad\u03c3\u03c4\u03c1\u03b5\u03c8\u03b5 \u03c4\u03bf \u03b1\u03bd\u03c4\u03af\u03c3\u03c4\u03bf\u03b9\u03c7\u03bf email. \u03a4\u03bf \u03c4\u03b5\u03bb\u03b5\u03c5\u03c4\u03b1\u03af\u03bf \u03b1\u03c5\u03c4\u03cc \u03cc\u03c1\u03b9\u03c3\u03bc\u03b1, \u00ab <code>\"Not found\"<\/code> \u00bb, \u03b5\u03af\u03bd\u03b1\u03b9 \u03b1\u03c5\u03c4\u03cc \u03c0\u03bf\u03c5 \u03b5\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 \u03cc\u03c4\u03b1\u03bd \u03b4\u03b5\u03bd \u03c5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03b1 \u2014 \u03ba\u03ac\u03c4\u03b9 \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03ba\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03bf \u03b1\u03c0\u03cc \u03c4\u03bf \u03ac\u03c3\u03c7\u03b7\u03bc\u03bf \u00ab <code>#N\/A<\/code> \u00bb \u03c4\u03b7\u03c2 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7\u03c2 VLOOKUP \u03c0\u03bf\u03c5 \u03c3\u03b5 \u03ba\u03bf\u03b9\u03c4\u03ac\u03b6\u03b5\u03b9 \u03ba\u03b1\u03c4\u03ac\u03bc\u03b1\u03c4\u03b1.<\/p>\n<p>\u03a3\u03cd\u03c1\u03b5 \u03c4\u03bf \u03c0\u03c1\u03bf\u03c2 \u03c4\u03b1 \u03ba\u03ac\u03c4\u03c9 \u03c3\u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u03ba\u03b1\u03b9 \u03ba\u03ac\u03b8\u03b5 \u03c3\u03b5\u03b9\u03c1\u03ac \u03b8\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03b5\u03b9 \u03c4\u03bf \u03b1\u03bd\u03c4\u03af\u03c3\u03c4\u03bf\u03b9\u03c7\u03bf \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03bf \u03c4\u03b7\u03c2. \u03a4\u03ad\u03bb\u03b5\u03b9\u03b1.<\/p>\n<p>\u03a7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03c0\u03b1\u03bb\u03b1\u03b9\u03cc\u03c4\u03b5\u03c1\u03b7 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7 \u03c4\u03bf\u03c5 Excel \u03c0\u03bf\u03c5 \u03b4\u03b5\u03bd \u03b4\u03b9\u03b1\u03b8\u03ad\u03c4\u03b5\u03b9 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 XLOOKUP; \u039f\u03b9 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 INDEX\/MATCH \u03b5\u03c0\u03b9\u03c4\u03b5\u03bb\u03bf\u03cd\u03bd \u03c4\u03b7\u03bd \u03af\u03b4\u03b9\u03b1 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b1:<\/p>\n<pre><code class=\"excel language-excel\">=INDEX(Sheet2!B:B, MATCH(A2, Sheet2!A:A, 0))\n<\/code><\/pre>\n<p>\u03a4\u03bf \u00ab <code>0<\/code> \u00bb \u03c3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 MATCH \u03b5\u03c0\u03b9\u03b2\u03ac\u03bb\u03bb\u03b5\u03b9 \u03b1\u03ba\u03c1\u03b9\u03b2\u03ae \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03af\u03c7\u03b9\u03c3\u03b7, \u03ba\u03ac\u03c4\u03b9 \u03c0\u03bf\u03c5 \u03c3\u03c7\u03b5\u03b4\u03cc\u03bd \u03c0\u03ac\u03bd\u03c4\u03b1 \u03b5\u03c0\u03b9\u03b8\u03c5\u03bc\u03b5\u03af\u03c4\u03b5 \u03cc\u03c4\u03b1\u03bd \u03c0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03b1\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac. \u0391\u03bd \u03c4\u03bf \u03c0\u03b1\u03c1\u03b1\u03bb\u03b5\u03af\u03c8\u03b5\u03c4\u03b5, \u03c4\u03bf Excel \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03b5\u03af \u03ba\u03b1\u03c4\u03ac \u03c0\u03c1\u03bf\u03c3\u03ad\u03b3\u03b3\u03b9\u03c3\u03b7 \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03af\u03c7\u03b9\u03c3\u03b7, \u03b7 \u03bf\u03c0\u03bf\u03af\u03b1 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c3\u03b9\u03c9\u03c0\u03b7\u03bb\u03ac \u03bb\u03b1\u03bd\u03b8\u03b1\u03c3\u03bc\u03ad\u03bd\u03b5\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03c3\u03b5 \u03bc\u03b7 \u03c4\u03b1\u03be\u03b9\u03bd\u03bf\u03bc\u03b7\u03bc\u03ad\u03bd\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1. \u0388\u03bd\u03b1 \u03ba\u03bb\u03b1\u03c3\u03b9\u03ba\u03cc \u03c3\u03b9\u03c9\u03c0\u03b7\u03bb\u03cc \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1.<\/p>\n<div style=\"margin: 24px 0;\">\n<table class=\"pb-table\" style=\"width: 100%; border-collapse: separate; border-spacing: 0; font-size: 15px; line-height: 1.55; border: 1px solid #e5e7eb; border-radius: 10px;\">\n<thead>\n<tr>\n<th style=\"background: #4f46e5; color: #ffffff; text-align: left; padding: 12px 16px; font-weight: 600; border-top-left-radius: 9px;\">\u039c\u03ad\u03b8\u03bf\u03b4\u03bf\u03c2<\/th>\n<th style=\"background: #4f46e5; color: #ffffff; text-align: left; padding: 12px 16px; font-weight: 600;\">\u0388\u03ba\u03b4\u03bf\u03c3\u03b7 \u03c4\u03bf\u03c5 Excel<\/th>\n<th style=\"background: #4f46e5; color: #ffffff; text-align: left; padding: 12px 16px; font-weight: 600;\">\u0399\u03b4\u03b1\u03bd\u03b9\u03ba\u03cc \u03b3\u03b9\u03b1<\/th>\n<th style=\"background: #4f46e5; color: #ffffff; text-align: left; padding: 12px 16px; font-weight: 600; border-top-right-radius: 9px;\">\u03a0\u03c1\u03bf\u03c3\u03bf\u03c7\u03ae<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">XLOOKUP<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">365 \/ 2021+<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">\u0391\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03af\u03c7\u03b9\u03c3\u03b7 \u03b2\u03ac\u03c3\u03b5\u03b9 \u03b1\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03bf\u03cd, \u03c0\u03b9\u03bf \u03ba\u03b1\u03b8\u03b1\u03c1\u03ae \u03c3\u03cd\u03bd\u03c4\u03b1\u03be\u03b7<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">\u0394\u03b5\u03bd \u03b4\u03b9\u03b1\u03c4\u03af\u03b8\u03b5\u03c4\u03b1\u03b9 \u03c3\u03b5 \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u03c0\u03c1\u03b9\u03bd \u03b1\u03c0\u03cc \u03c4\u03bf 2021<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">INDEX\/MATCH<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">\u038c\u03bb\u03b5\u03c2 \u03bf\u03b9 \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">\u038a\u03b4\u03b9\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1, \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af \u03c0\u03b1\u03bd\u03c4\u03bf\u03cd<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">\u0394\u03cd\u03bf \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03ad\u03bd\u03b8\u03b5\u03c3\u03b7<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">VLOOKUP<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">\u038c\u03bb\u03b5\u03c2 \u03bf\u03b9 \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">\u039c\u03cc\u03bd\u03bf \u03b1\u03c1\u03c7\u03b5\u03af\u03b1 \u03c0\u03b1\u03bb\u03b1\u03b9\u03bf\u03cd \u03c4\u03cd\u03c0\u03bf\u03c5<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #ffffff;\">\u0394\u03b5\u03bd \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af \u03b1\u03bd \u03bc\u03b5\u03c4\u03b1\u03ba\u03b9\u03bd\u03b7\u03b8\u03bf\u03cd\u03bd \u03bf\u03b9 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">\u03a3\u03c5\u03b3\u03c7\u03ce\u03bd\u03b5\u03c5\u03c3\u03b7 Power Query<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">2016+<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">\u039c\u03b5\u03b3\u03ac\u03bb\u03b1 \u03c3\u03cd\u03bd\u03bf\u03bb\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03bc\u03b5 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03b1\u03bd\u03b1\u03bd\u03ad\u03c9\u03c3\u03b7\u03c2<\/td>\n<td style=\"padding: 11px 16px; border-top: 1px solid #e5e7eb; color: #374151; background: #f9fafb;\">\u03a0\u03b9\u03bf \u03b1\u03c0\u03b1\u03b9\u03c4\u03b7\u03c4\u03b9\u03ba\u03ae \u03b1\u03c1\u03c7\u03b9\u03ba\u03ae \u03c1\u03cd\u03b8\u03bc\u03b9\u03c3\u03b7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\u0391\u03be\u03af\u03b6\u03b5\u03b9 \u03bd\u03b1 \u03b3\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5: \u03a4\u03bf Power Query \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03b5\u03c0\u03af\u03c3\u03b7\u03c2 \u03bd\u03b1 \u03b5\u03ba\u03c4\u03b5\u03bb\u03ad\u03c3\u03b5\u03b9 \u03b1\u03c5\u03c4\u03ae \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1 \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03af\u03c7\u03b9\u03c3\u03b7\u03c2, \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ce\u03bd\u03c4\u03b1\u03c2 \u03c4\u03b7 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u00ab\u03a3\u03c5\u03b3\u03c7\u03ce\u03bd\u03b5\u03c5\u03c3\u03b7\u00bb (Merge) \u03b1\u03bd\u03c4\u03af \u03b3\u03b9\u03b1 \u00ab\u03a0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7\u00bb (Append). \u0393\u03b9\u03b1 \u03bc\u03b9\u03b1 \u03b5\u03c6\u03ac\u03c0\u03b1\u03be \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ac, \u03b7 \u03c3\u03cd\u03bd\u03c4\u03b1\u03be\u03b7 \u03b5\u03bd\u03cc\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03b1\u03c7\u03cd\u03c4\u03b5\u03c1\u03b7. \u0393\u03b9\u03b1 \u03ba\u03ac\u03c4\u03b9 \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03b1\u03bd\u03b1\u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03b5\u03af\u03c4\u03b5 \u03ba\u03ac\u03b8\u03b5 \u03bc\u03ae\u03bd\u03b1 \u03bc\u03b5 \u03c7\u03b9\u03bb\u03b9\u03ac\u03b4\u03b5\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2, \u03b7 \u03c3\u03c5\u03b3\u03c7\u03ce\u03bd\u03b5\u03c5\u03c3\u03b7 \u03c4\u03bf\u03c5 Power Query \u03ad\u03c7\u03b5\u03b9 \u03ba\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03b7 \u03ba\u03bb\u03b9\u03bc\u03ac\u03ba\u03c9\u03c3\u03b7 \u03ba\u03b1\u03b9 \u03b4\u03b5\u03bd \u03b8\u03b1 \u03b5\u03c0\u03b9\u03b2\u03c1\u03b1\u03b4\u03cd\u03bd\u03b5\u03b9 \u03c4\u03bf \u03b1\u03c1\u03c7\u03b5\u03af\u03bf \u03c3\u03b1\u03c2, \u03cc\u03c0\u03c9\u03c2 \u03b8\u03b1 \u03c3\u03c5\u03bd\u03ad\u03b2\u03b1\u03b9\u03bd\u03b5 \u03bc\u03b5 \u03b4\u03ad\u03ba\u03b1 \u03c7\u03b9\u03bb\u03b9\u03ac\u03b4\u03b5\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5\u03c2 XLOOKUP.<\/p>\n<h2>\u038c\u03c4\u03b1\u03bd \u03b8\u03ad\u03bb\u03b5\u03c4\u03b5 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ac \u03bd\u03b1 \u03c3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03ce\u03c3\u03b5\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1<\/h2>\n<p>\u03a5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03c4\u03c1\u03af\u03c4\u03b7, \u03c0\u03b9\u03bf \u03b4\u03b9\u03b1\u03ba\u03c1\u03b9\u03c4\u03b9\u03ba\u03ae \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae \u03c0\u03bf\u03c5 \u03c0\u03bf\u03bb\u03bb\u03bf\u03af \u03be\u03b5\u03c7\u03bd\u03bf\u03cd\u03bd. \u0391\u03bd \u03bf \u03c3\u03c4\u03cc\u03c7\u03bf\u03c2 \u03c3\u03b1\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bd\u03b1 <strong>\u03c3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03ce\u03c3\u03b5\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1<\/strong> \u03bc\u03b5 \u03c4\u03bf\u03bd \u03c4\u03c1\u03cc\u03c0\u03bf \u03c0\u03bf\u03c5 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af <strong>\u03c4\u03bf Excel<\/strong> \u2014\u03b4\u03b7\u03bb\u03b1\u03b4\u03ae, \u03b1\u03bd \u03b8\u03ad\u03bb\u03b5\u03c4\u03b5 \u03bd\u03b1 \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c4\u03b1 \u03b1\u03b8\u03c1\u03bf\u03af\u03c3\u03bc\u03b1\u03c4\u03b1 \u03ae \u03bf\u03b9 \u03bc\u03ad\u03c3\u03bf\u03b9 \u03cc\u03c1\u03bf\u03b9 \u03c3\u03b5 \u03cc\u03bb\u03b1 \u03c4\u03b1 \u03c6\u03cd\u03bb\u03bb\u03b1, \u03b1\u03bd\u03c4\u03af \u03bd\u03b1 \u03b4\u03b9\u03b1\u03c4\u03b7\u03c1\u03bf\u03cd\u03bd\u03c4\u03b1\u03b9 \u03cc\u03bb\u03b5\u03c2 \u03bf\u03b9 \u03b1\u03c1\u03c7\u03b9\u03ba\u03ad\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2\u2014 \u03c4\u03bf Excel \u03b4\u03b9\u03b1\u03b8\u03ad\u03c4\u03b5\u03b9 \u03ad\u03bd\u03b1 \u03b5\u03b9\u03b4\u03b9\u03ba\u03cc \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf \u03b3\u03b9\u03b1 \u03b1\u03c5\u03c4\u03cc. \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 &gt; \u03a3\u03c5\u03b3\u03ba\u03ad\u03bd\u03c4\u03c1\u03c9\u03c3\u03b7.<\/p>\n<p>\u0395\u03c0\u03b9\u03bb\u03ad\u03be\u03c4\u03b5 \u03ba\u03b1\u03b9 \u03c4\u03b9\u03c2 \u03b4\u03cd\u03bf \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ad\u03c2, \u03b4\u03b9\u03b1\u03bb\u03ad\u03be\u03c4\u03b5 \u03c4\u03b7 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03c0\u03bf\u03c5 \u03b8\u03ad\u03bb\u03b5\u03c4\u03b5 (\u0386\u03b8\u03c1\u03bf\u03b9\u03c3\u03bc\u03b1, \u039c\u03ad\u03c3\u03bf\u03c2 \u03cc\u03c1\u03bf\u03c2, \u0391\u03c1\u03b9\u03b8\u03bc\u03cc\u03c2) \u03ba\u03b1\u03b9 \u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u03b8\u03b1 \u03c3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03ce\u03c3\u03b5\u03b9 \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03b6\u03bf\u03bd\u03c4\u03b1\u03c2 \u03c4\u03b9\u03c2 \u03b5\u03c4\u03b9\u03ba\u03ad\u03c4\u03b5\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ce\u03bd \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b7\u03bb\u03ce\u03bd. <a href=\"https:\/\/spreadsheeto.com\/consolidate\/\" rel=\"nofollow noopener\" target=\"_blank\">\u039f \u03bf\u03b4\u03b7\u03b3\u03cc\u03c2 \u03c4\u03bf\u03c5 Spreadsheeto \u03b3\u03b9\u03b1 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u00abconsolidate\u00bb<\/a> \u03b1\u03bd\u03b1\u03bb\u03cd\u03b5\u03b9 \u03bb\u03b5\u03c0\u03c4\u03bf\u03bc\u03b5\u03c1\u03ce\u03c2 \u03c4\u03bf \u03c0\u03b1\u03c1\u03ac\u03b8\u03c5\u03c1\u03bf \u03b4\u03b9\u03b1\u03bb\u03cc\u03b3\u03bf\u03c5. \u0395\u03af\u03bd\u03b1\u03b9 \u03b7 \u03c3\u03c9\u03c3\u03c4\u03ae \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae \u03cc\u03c4\u03b1\u03bd \u03b4\u03b5\u03bd \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c3\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03c5\u03c0\u03bf\u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03b5\u03c2 \u03bb\u03b5\u03c0\u03c4\u03bf\u03bc\u03ad\u03c1\u03b5\u03b9\u03b5\u03c2, \u03b1\u03bb\u03bb\u03ac \u03bc\u03cc\u03bd\u03bf \u03c4\u03b1 \u03c3\u03cd\u03bd\u03bf\u03bb\u03b1 \u2014 \u03cc\u03c0\u03c9\u03c2, \u03b3\u03b9\u03b1 \u03c0\u03b1\u03c1\u03ac\u03b4\u03b5\u03b9\u03b3\u03bc\u03b1, \u03c4\u03b7 \u03c3\u03c5\u03b3\u03c7\u03ce\u03bd\u03b5\u03c5\u03c3\u03b7 \u03c4\u03c9\u03bd \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03c9\u03bd \u03c0\u03c9\u03bb\u03ae\u03c3\u03b5\u03c9\u03bd \u03b1\u03bd\u03ac \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae \u03c3\u03b5 \u03bc\u03af\u03b1 \u03c3\u03cd\u03bd\u03bf\u03c8\u03b7.<\/p>\n<p>\u039c\u03b7\u03bd \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03c4\u03b7 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u00abConsolidate\u00bb \u03cc\u03c4\u03b1\u03bd \u03c3\u03c4\u03b7\u03bd \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc\u03c4\u03b7\u03c4\u03b1 \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c3\u03c4\u03b5 \u03ba\u03ac\u03b8\u03b5 \u03c3\u03b5\u03b9\u03c1\u03ac \u03b1\u03bd\u03ad\u03c0\u03b1\u03c6\u03b7. \u0397 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03b1\u03c5\u03c4\u03ae \u03c3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03ce\u03bd\u03b5\u03b9 \u03c4\u03b1 \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03b1 \u03ba\u03b1\u03b9 \u03c7\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7\u03bd \u03bb\u03b5\u03c0\u03c4\u03bf\u03bc\u03ad\u03c1\u03b5\u03b9\u03b1. \u03a0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03bc\u03b9\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7\u03c2 \u03c0\u03bf\u03c5 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b1\u03b9 \u03c3\u03b5 \u03bb\u03ac\u03b8\u03bf\u03c2 \u03c0\u03bb\u03b1\u03af\u03c3\u03b9\u03bf.<\/p>\n<h2>\u0391\u03bd\u03c4\u03b9\u03bc\u03b5\u03c4\u03ce\u03c0\u03b9\u03c3\u03b7 \u03c0\u03c1\u03bf\u03b2\u03bb\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd \u03c3\u03c4\u03bf Combine<\/h2>\n<p>\u03a4\u03b1 \u03c0\u03c1\u03ac\u03b3\u03bc\u03b1\u03c4\u03b1 \u03c0\u03ac\u03bd\u03b5 \u03c3\u03c4\u03c1\u03b1\u03b2\u03ac \u03bc\u03b5 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ad\u03c8\u03b9\u03bc\u03bf\u03c5\u03c2 \u03c4\u03c1\u03cc\u03c0\u03bf\u03c5\u03c2. \u0391\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03bf\u03cd\u03bd \u03c4\u03b1 \u03c3\u03c5\u03bd\u03b7\u03b8\u03ad\u03c3\u03c4\u03b5\u03c1\u03b1 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 \u03ba\u03b1\u03b9 \u03bf\u03b9 \u03bb\u03cd\u03c3\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5\u03c2.<\/p>\n<p>\u039f\u03b9 \u03b4\u03b9\u03c0\u03bb\u03ad\u03c2 \u03ba\u03b5\u03c6\u03b1\u03bb\u03af\u03b4\u03b5\u03c2 \u03bc\u03b5\u03c4\u03ac \u03b1\u03c0\u03cc \u03bc\u03b9\u03b1 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7 \u03c3\u03b7\u03bc\u03b1\u03af\u03bd\u03bf\u03c5\u03bd \u03c3\u03c7\u03b5\u03b4\u03cc\u03bd \u03c0\u03ac\u03bd\u03c4\u03b1 \u03cc\u03c4\u03b9 \u03c4\u03b1 \u03bf\u03bd\u03cc\u03bc\u03b1\u03c4\u03b1 \u03c4\u03c9\u03bd \u03c3\u03c4\u03b7\u03bb\u03ce\u03bd \u03c4\u03c9\u03bd \u03b4\u03cd\u03bf \u03c0\u03b9\u03bd\u03ac\u03ba\u03c9\u03bd \u03c0\u03c1\u03bf\u03ad\u03bb\u03b5\u03c5\u03c3\u03b7\u03c2 \u03b4\u03b5\u03bd \u03c4\u03b1\u03b9\u03c1\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd. \u0395\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c8\u03c4\u03b5, \u03bc\u03b5\u03c4\u03bf\u03bd\u03bf\u03bc\u03ac\u03c3\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03c4\u03b1\u03b9\u03c1\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd \u03b1\u03ba\u03c1\u03b9\u03b2\u03ce\u03c2 \u2014 \u03c3\u03c5\u03bc\u03c0\u03b5\u03c1\u03b9\u03bb\u03b1\u03bc\u03b2\u03b1\u03bd\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03c9\u03bd \u03ba\u03b5\u03bd\u03ce\u03bd \u03ba\u03b1\u03b9 \u03c4\u03b7\u03c2 \u03c7\u03c1\u03ae\u03c3\u03b7\u03c2 \u03ba\u03b5\u03c6\u03b1\u03bb\u03b1\u03af\u03c9\u03bd \u2014 \u03ba\u03b1\u03b9, \u03c3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1, \u03b1\u03bd\u03b1\u03bd\u03b5\u03ce\u03c3\u03c4\u03b5 \u03c4\u03b7 \u03c3\u03b5\u03bb\u03af\u03b4\u03b1.<\/p>\n<p>\u039f\u03b9 \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03bf\u03c5\u03bd \u03c4\u03bf \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1 \u00ab <code>#N\/A<\/code> \u00bb \u03c3\u03b5 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03c0\u03bf\u03c5 \u03b3\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5 \u03cc\u03c4\u03b9 \u03c5\u03c0\u03ac\u03c1\u03c7\u03bf\u03c5\u03bd; \u0395\u03bd\u03bd\u03ad\u03b1 \u03c3\u03c4\u03b9\u03c2 \u03b4\u03ad\u03ba\u03b1 \u03c6\u03bf\u03c1\u03ad\u03c2 \u03c0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03b1\u03c3\u03c5\u03bc\u03c6\u03c9\u03bd\u03af\u03b1 \u03c4\u03cd\u03c0\u03bf\u03c5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd. \u0388\u03bd\u03b1 \u03c6\u03cd\u03bb\u03bb\u03bf \u03b1\u03c0\u03bf\u03b8\u03b7\u03ba\u03b5\u03cd\u03b5\u03b9 \u03c4\u03bf \u03b1\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03cc \u03c9\u03c2 \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf, \u03b5\u03bd\u03ce \u03c4\u03bf \u03ac\u03bb\u03bb\u03bf \u03c9\u03c2 \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc. \u03a6\u03b1\u03af\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c0\u03b1\u03bd\u03bf\u03bc\u03bf\u03b9\u03cc\u03c4\u03c5\u03c0\u03b1 \u03c3\u03c4\u03b7\u03bd \u03bf\u03b8\u03cc\u03bd\u03b7, \u03b1\u03bb\u03bb\u03ac \u03c4\u03bf Excel \u03b1\u03bd\u03c4\u03b9\u03bc\u03b5\u03c4\u03c9\u03c0\u03af\u03b6\u03b5\u03b9 \u03c4\u03bf \u00ab1024\u00bb \u03ba\u03b1\u03b9 \u03c4\u03bf 1024 \u03c9\u03c2 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ac \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03b1. \u039c\u03b5\u03c4\u03b1\u03c4\u03c1\u03ad\u03c8\u03c4\u03b5 \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03c4\u03b7 \u03bc\u03af\u03b1 \u03c0\u03bb\u03b5\u03c5\u03c1\u03ac, \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03c4\u03b1\u03b9\u03c1\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd \u03ba\u03b1\u03b9 \u03c4\u03b1 \u03b4\u03cd\u03bf.<\/p>\n<p>\u039f\u03b9 \u03b5\u03c0\u03b9\u03c0\u03bb\u03ad\u03bf\u03bd \u03ba\u03b5\u03bd\u03ad\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03c0\u03bf\u03c5 \u03b5\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03bf\u03bd\u03c4\u03b1\u03b9 \u03ba\u03c1\u03c5\u03c6\u03ac \u03c3\u03c4\u03bf\u03bd \u03c3\u03c5\u03bd\u03b4\u03c5\u03b1\u03c3\u03bc\u03ad\u03bd\u03bf \u03c0\u03af\u03bd\u03b1\u03ba\u03ac \u03c3\u03b1\u03c2 \u03c3\u03c5\u03bd\u03ae\u03b8\u03c9\u03c2 \u03bf\u03c6\u03b5\u03af\u03bb\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c3\u03b5 \u03ba\u03b5\u03bd\u03ad\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03b5\u03bd\u03c4\u03cc\u03c2 \u03c4\u03b7\u03c2 \u03b1\u03c1\u03c7\u03b9\u03ba\u03ae\u03c2 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c0\u03bf\u03c5 \u03bc\u03b5\u03c4\u03b1\u03c6\u03ad\u03c1\u03b8\u03b7\u03ba\u03b1\u03bd \u03ba\u03b1\u03c4\u03ac \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b1. \u03a6\u03b9\u03bb\u03c4\u03c1\u03ac\u03c1\u03b5\u03c4\u03ad \u03c4\u03b9\u03c2 \u03c3\u03c4\u03b7\u03bd \u03c0\u03b7\u03b3\u03ae \u03c0\u03c1\u03b9\u03bd \u03b1\u03c0\u03cc \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03bd\u03c9\u03c3\u03b7.<\/p>\n<div class=\"pb-tipbox pb-tipbox-warning\" style=\"background: #fffbeb; border-left: 4px solid #f59e0b; border-radius: 8px; padding: 14px 18px; margin: 24px 0;\">\n<div style=\"font-weight: bold; color: #b45309; font-size: 13px; letter-spacing: 1px; margin-bottom: 5px;\">\u03a0\u03a1\u039f\u0395\u0399\u0394\u039f\u03a0\u039f\u0399\u0397\u03a3\u0397<\/div>\n<div style=\"color: #1f2937;\">\u03a0\u03c1\u03b9\u03bd \u03b5\u03bc\u03c0\u03b9\u03c3\u03c4\u03b5\u03c5\u03c4\u03b5\u03af\u03c4\u03b5 \u03bf\u03c0\u03bf\u03b9\u03bf\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03c3\u03c5\u03bd\u03bf\u03bb\u03b9\u03ba\u03cc \u03ac\u03b8\u03c1\u03bf\u03b9\u03c3\u03bc\u03b1, \u03b5\u03bb\u03ad\u03b3\u03be\u03c4\u03b5 \u03b4\u03b9\u03b1\u03c3\u03c4\u03b1\u03c5\u03c1\u03c9\u03c4\u03b9\u03ba\u03ac \u03c4\u03bf\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c4\u03c9\u03bd \u03c3\u03b5\u03b9\u03c1\u03ce\u03bd. \u0391\u03b8\u03c1\u03bf\u03af\u03c3\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c0\u03c1\u03bf\u03ad\u03bb\u03b5\u03c5\u03c3\u03b7\u03c2 \u03ba\u03b1\u03b9, \u03c3\u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03c7\u03b5\u03b9\u03b1, \u03c3\u03c5\u03b3\u03ba\u03c1\u03af\u03bd\u03b5\u03c4\u03ad \u03c4\u03b9\u03c2 \u03bc\u03b5 \u03c4\u03bf \u03c3\u03c5\u03b3\u03c7\u03c9\u03bd\u03b5\u03c5\u03bc\u03ad\u03bd\u03bf \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1. \u0395\u03ac\u03bd \u03bf\u03b9 \u03b1\u03c1\u03b9\u03b8\u03bc\u03bf\u03af \u03b4\u03b5\u03bd \u03c4\u03b1\u03b9\u03c1\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd, \u03ba\u03ac\u03c4\u03b9 \u03ad\u03c7\u03b5\u03b9 \u03c0\u03b1\u03c1\u03b1\u03bb\u03b5\u03b9\u03c6\u03b8\u03b5\u03af \u03ae \u03ad\u03c7\u03b5\u03b9 \u03b4\u03b9\u03c0\u03bb\u03b1\u03c3\u03b9\u03b1\u03c3\u03c4\u03b5\u03af, \u03ba\u03b1\u03b9 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03bf\u03bb\u03cd \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03bf \u03bd\u03b1 \u03c4\u03bf \u03b5\u03bd\u03c4\u03bf\u03c0\u03af\u03c3\u03b5\u03c4\u03b5 \u03c4\u03ce\u03c1\u03b1 \u03c0\u03b1\u03c1\u03ac \u03bc\u03b5\u03c4\u03ac \u03c4\u03b7\u03bd \u03b1\u03c0\u03bf\u03c3\u03c4\u03bf\u03bb\u03ae \u03c4\u03b7\u03c2 \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ac\u03c2.<\/div>\n<\/div>\n<p>\u039a\u03b1\u03b9 \u03b1\u03bd \u03c4\u03bf \u03b1\u03c1\u03c7\u03b5\u03af\u03bf \u03c3\u03b1\u03c2 \u03b1\u03c1\u03c7\u03af\u03c3\u03b5\u03b9 \u03bd\u03b1 \u03ba\u03b9\u03bd\u03b5\u03af\u03c4\u03b1\u03b9 \u03c0\u03bf\u03bb\u03cd \u03b1\u03c1\u03b3\u03ac \u03bc\u03b5\u03c4\u03ac \u03b1\u03c0\u03cc \u03bc\u03b9\u03b1 \u03bc\u03b5\u03b3\u03ac\u03bb\u03b7 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b1\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7\u03c2, \u03b1\u03c5\u03c4\u03cc \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03c3\u03ae\u03bc\u03b1 \u03c3\u03b1\u03c2 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03b2\u03b5\u03af\u03c4\u03b5 \u03c3\u03c4\u03bf Power Query. \u03a7\u03b9\u03bb\u03b9\u03ac\u03b4\u03b5\u03c2 \u03b5\u03c5\u03bc\u03b5\u03c4\u03ac\u03b2\u03bb\u03b7\u03c4\u03bf\u03b9 \u03c4\u03cd\u03c0\u03bf\u03b9 \u03c0\u03bf\u03c5 \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03bf\u03bd\u03c4\u03b1\u03b9 \u03b5\u03ba \u03bd\u03ad\u03bf\u03c5 \u03c3\u03b5 \u03ba\u03ac\u03b8\u03b5 \u03b5\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b8\u03b1 \u03b5\u03be\u03b1\u03bd\u03c4\u03bb\u03ae\u03c3\u03bf\u03c5\u03bd \u03b1\u03ba\u03cc\u03bc\u03b7 \u03ba\u03b1\u03b9 \u03ad\u03bd\u03b1\u03bd \u03b1\u03c1\u03ba\u03b5\u03c4\u03ac \u03b9\u03c3\u03c7\u03c5\u03c1\u03cc \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03ae. \u0397 Ablebits \u03c0\u03b1\u03c1\u03ad\u03c7\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03ba\u03b1\u03bb\u03ae \u03b5\u03c0\u03b9\u03c3\u03ba\u03cc\u03c0\u03b7\u03c3\u03b7 \u03c4\u03c9\u03bd <a href=\"https:\/\/www.ablebits.com\/office-addins-blog\/combine-excel-spreadsheets\/\" rel=\"nofollow noopener\" target=\"_blank\">\u03c0\u03b9\u03bf \u03b1\u03c0\u03b1\u03b9\u03c4\u03b7\u03c4\u03b9\u03ba\u03ce\u03bd \u03c3\u03b5\u03bd\u03b1\u03c1\u03af\u03c9\u03bd \u03c3\u03c5\u03b3\u03c7\u03ce\u03bd\u03b5\u03c5\u03c3\u03b7\u03c2<\/a>, \u03b1\u03bd \u03c7\u03b5\u03b9\u03c1\u03af\u03b6\u03b5\u03c3\u03c4\u03b5 \u03c0\u03bf\u03bb\u03bb\u03ac \u03bc\u03b5\u03b3\u03ac\u03bb\u03b1 \u03b2\u03b9\u03b2\u03bb\u03af\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2.<\/p>\n<h2>\u03a3\u03c5\u03c7\u03bd\u03ad\u03c2 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/h2>\n<p><strong>\u03a0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03c9 \u03c4\u03bf Power Query \u03ae \u03ad\u03bd\u03b1\u03bd \u03c4\u03cd\u03c0\u03bf \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03c5\u03ac\u03c3\u03c9 \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1;<\/strong><br \/>\n\u0395\u03be\u03b1\u03c1\u03c4\u03ac\u03c4\u03b1\u03b9 \u03b1\u03c0\u03cc \u03c4\u03bf \u03b1\u03bd \u03b7 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b5\u03c6\u03ac\u03c0\u03b1\u03be \u03ae \u03b5\u03c0\u03b1\u03bd\u03b1\u03bb\u03b1\u03bc\u03b2\u03b1\u03bd\u03cc\u03bc\u03b5\u03bd\u03b7. \u0393\u03b9\u03b1 \u03bc\u03b9\u03b1 \u03bc\u03b5\u03bc\u03bf\u03bd\u03c9\u03bc\u03ad\u03bd\u03b7 \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ac \u03c0\u03bf\u03c5 \u03b4\u03b5\u03bd \u03b8\u03b1 \u03be\u03b1\u03bd\u03b1\u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c0\u03bf\u03c4\u03ad, \u03bf \u03c4\u03cd\u03c0\u03bf\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03bf\u03c2 \u03c3\u03c4\u03b7 \u03c3\u03cd\u03bd\u03c4\u03b1\u03be\u03b7. \u0393\u03b9\u03b1 \u03bf\u03c4\u03b9\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03b1\u03bd\u03b1\u03bd\u03b5\u03ce\u03bd\u03b5\u03c4\u03b5 \u03ba\u03ac\u03b8\u03b5 \u03bc\u03ae\u03bd\u03b1, \u03c4\u03bf Power Query \u03c5\u03c0\u03b5\u03c1\u03b9\u03c3\u03c7\u03cd\u03b5\u03b9, \u03ba\u03b1\u03b8\u03ce\u03c2 \u03b1\u03bd\u03b1\u03bd\u03b5\u03ce\u03bd\u03b5\u03c4\u03b1\u03b9 \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03bb\u03b9\u03ba, \u03b1\u03bd\u03c4\u03af \u03bd\u03b1 \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03b1\u03bd\u03b1\u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03b5\u03af\u03c4\u03b5 \u03c4\u03bf\u03c5\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5\u03c2 \u03ba\u03ac\u03b8\u03b5 \u03c6\u03bf\u03c1\u03ac.<\/p>\n<p><strong>\u03a0\u03bf\u03b9\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b7 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03ac \u03bc\u03b5\u03c4\u03b1\u03be\u03cd \u03c4\u03b7\u03c2 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7\u03c2 \u03ba\u03b1\u03b9 \u03c4\u03b7\u03c2 \u03c3\u03c5\u03b3\u03c7\u03ce\u03bd\u03b5\u03c5\u03c3\u03b7\u03c2;<\/strong><br \/>\n\u0397 \u03c0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7 \u03c4\u03bf\u03c0\u03bf\u03b8\u03b5\u03c4\u03b5\u03af \u03c4\u03b9\u03c2 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03b7 \u03bc\u03af\u03b1 \u03ba\u03ac\u03c4\u03c9 \u03b1\u03c0\u03cc \u03c4\u03b7\u03bd \u03ac\u03bb\u03bb\u03b7, \u03cc\u03c4\u03b1\u03bd \u03ba\u03b1\u03b9 \u03c4\u03b1 \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03bf\u03c5\u03bd \u03c4\u03bf\u03bd \u03af\u03b4\u03b9\u03bf \u03c4\u03cd\u03c0\u03bf \u03b5\u03b3\u03b3\u03c1\u03b1\u03c6\u03ce\u03bd. \u0397 \u03c3\u03c5\u03b3\u03c7\u03ce\u03bd\u03b5\u03c5\u03c3\u03b7 (\u03ae \u03b7 \u03b1\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7) \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03b6\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03b4\u03af\u03c0\u03bb\u03b1-\u03b4\u03af\u03c0\u03bb\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ce\u03bd\u03c4\u03b1\u03c2 \u03ad\u03bd\u03b1 \u03ba\u03bf\u03b9\u03bd\u03cc \u03b1\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03cc, \u03cc\u03c4\u03b1\u03bd \u03c4\u03b1 \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03bf\u03c5\u03bd \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ad\u03c2 \u03bb\u03b5\u03c0\u03c4\u03bf\u03bc\u03ad\u03c1\u03b5\u03b9\u03b5\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b9\u03c2 \u03af\u03b4\u03b9\u03b5\u03c2 \u03b5\u03b3\u03b3\u03c1\u03b1\u03c6\u03ad\u03c2. \u03a0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03b5\u03bd\u03c4\u03b5\u03bb\u03ce\u03c2 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ad\u03c2 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b5\u03c2.<\/p>\n<p><strong>\u0395\u03af\u03bd\u03b1\u03b9 \u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 XLOOKUP \u03ba\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03b7 \u03b1\u03c0\u03cc \u03c4\u03b7 VLOOKUP \u03b3\u03b9\u03b1 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ad\u03bd\u03c9\u03c3\u03b7 \u03c6\u03cd\u03bb\u03bb\u03c9\u03bd;<\/strong><br \/>\n\u039d\u03b1\u03b9, \u03b1\u03bd \u03c4\u03b7 \u03b4\u03b9\u03b1\u03b8\u03ad\u03c4\u03b5\u03c4\u03b5. \u0397 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 XLOOKUP \u03c7\u03b5\u03b9\u03c1\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 \u03ad\u03bd\u03b1 \u03b5\u03bd\u03c3\u03c9\u03bc\u03b1\u03c4\u03c9\u03bc\u03ad\u03bd\u03bf \u03bc\u03ae\u03bd\u03c5\u03bc\u03b1 \u00ab\u03b4\u03b5\u03bd \u03b2\u03c1\u03ad\u03b8\u03b7\u03ba\u03b5\u00bb, \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ac \u03c0\u03c1\u03bf\u03c2 \u03c4\u03b1 \u03b1\u03c1\u03b9\u03c3\u03c4\u03b5\u03c1\u03ac \u03ae \u03c0\u03c1\u03bf\u03c2 \u03c4\u03b1 \u03b4\u03b5\u03be\u03b9\u03ac \u03ba\u03b1\u03b9 \u03b4\u03b5\u03bd \u03c0\u03b1\u03c1\u03bf\u03c5\u03c3\u03b9\u03ac\u03b6\u03b5\u03b9 \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1\u03c4\u03b1 \u03cc\u03c4\u03b1\u03bd \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03c2 \u03b5\u03b9\u03c3\u03ac\u03b3\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03c3\u03c4\u03ae\u03bb\u03b7. \u0397 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 VLOOKUP \u03b5\u03af\u03bd\u03b1\u03b9 \u03ba\u03b1\u03c4\u03ac\u03bb\u03bb\u03b7\u03bb\u03b7 \u03b3\u03b9\u03b1 \u03c0\u03b1\u03bb\u03b1\u03b9\u03cc\u03c4\u03b5\u03c1\u03b1 \u03b1\u03c1\u03c7\u03b5\u03af\u03b1, \u03b1\u03bb\u03bb\u03ac \u03b4\u03b5\u03bd \u03c5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03bb\u03cc\u03b3\u03bf\u03c2 \u03bd\u03b1 \u03be\u03b5\u03ba\u03b9\u03bd\u03ae\u03c3\u03b5\u03c4\u03b5 \u03bd\u03ad\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03bc\u03b5 \u03b1\u03c5\u03c4\u03ae\u03bd \u03c3\u03c4\u03bf Excel 2021 \u03ae \u03c3\u03c4\u03bf 365.<\/p>\n<p><strong>\u0393\u03b9\u03b1\u03c4\u03af \u03b7 \u03b1\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03ae \u03bc\u03bf\u03c5 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1\u03c4\u03b1, \u03b5\u03bd\u03ce \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c4\u03b1\u03b9\u03c1\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd \u03c3\u03b1\u03c6\u03ce\u03c2;<\/strong><br \/>\n\u03a3\u03c7\u03b5\u03b4\u03cc\u03bd \u03c0\u03ac\u03bd\u03c4\u03b1 <strong>\u03c0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1<\/strong> \u03b1\u03c3\u03c5\u03bc\u03c6\u03c9\u03bd\u03af\u03b1 \u03c4\u03cd\u03c0\u03bf\u03c5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd. \u03a3\u03b5 \u03ad\u03bd\u03b1 \u03c6\u03cd\u03bb\u03bb\u03bf \u03c4\u03bf \u03ba\u03bb\u03b5\u03b9\u03b4\u03af \u03b1\u03c0\u03bf\u03b8\u03b7\u03ba\u03b5\u03cd\u03b5\u03c4\u03b1\u03b9 \u03c9\u03c2 \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf, \u03b5\u03bd\u03ce \u03c3\u03c4\u03bf \u03ac\u03bb\u03bb\u03bf \u03c9\u03c2 \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc\u03c2. \u039c\u03bf\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd \u03af\u03b4\u03b9\u03b1, \u03b1\u03bb\u03bb\u03ac \u03c4\u03bf Excel \u03b4\u03b5\u03bd \u03c4\u03b1 \u03b8\u03b5\u03c9\u03c1\u03b5\u03af \u03b9\u03c3\u03bf\u03b4\u03cd\u03bd\u03b1\u03bc\u03b1. \u0395\u03bd\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03c4\u03b5 \u03c4\u03b7 \u03bc\u03bf\u03c1\u03c6\u03ae \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b9\u03c2 \u03b4\u03cd\u03bf \u03c0\u03bb\u03b5\u03c5\u03c1\u03ad\u03c2 \u03ba\u03b1\u03b9 \u03c4\u03b1 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03af\u03c7\u03b9\u03c3\u03b7\u03c2 \u03b8\u03b1 \u03b5\u03c0\u03b9\u03bb\u03c5\u03b8\u03bf\u03cd\u03bd.<\/p>\n<p><strong>\u039c\u03c0\u03bf\u03c1\u03ce \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03c5\u03ac\u03c3\u03c9 \u03c6\u03cd\u03bb\u03bb\u03b1 \u03b1\u03c0\u03cc \u03b4\u03cd\u03bf \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ac \u03b2\u03b9\u03b2\u03bb\u03af\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2;<\/strong><br \/>\n\u039d\u03b1\u03b9. \u03a4\u03bf Power Query \u03c3\u03c5\u03bd\u03b4\u03ad\u03b5\u03c4\u03b1\u03b9 \u03bc\u03b5 \u03b5\u03be\u03c9\u03c4\u03b5\u03c1\u03b9\u03ba\u03ac \u03b1\u03c1\u03c7\u03b5\u03af\u03b1 \u03bc\u03ad\u03c3\u03c9 \u03c4\u03c9\u03bd \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ce\u03bd \u00ab\u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1\u00bb &gt; \u00ab\u039b\u03ae\u03c8\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd\u00bb &gt; \u00ab\u0391\u03c0\u03cc \u03b1\u03c1\u03c7\u03b5\u03af\u03bf\u00bb &gt; \u00ab\u0391\u03c0\u03cc \u03b2\u03b9\u03b2\u03bb\u03af\u03bf \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2\u00bb. \u03a4\u03b1 \u03b2\u03ae\u03bc\u03b1\u03c4\u03b1 \u00ab\u03a0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7\u00bb \u03ba\u03b1\u03b9 \u00ab\u03a3\u03c5\u03b3\u03c7\u03ce\u03bd\u03b5\u03c5\u03c3\u03b7\u00bb \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bd \u03b1\u03ba\u03c1\u03b9\u03b2\u03ce\u03c2 \u03bc\u03b5 \u03c4\u03bf\u03bd \u03af\u03b4\u03b9\u03bf \u03c4\u03c1\u03cc\u03c0\u03bf, \u03bc\u03cc\u03bb\u03b9\u03c2 \u03c6\u03bf\u03c1\u03c4\u03c9\u03b8\u03bf\u03cd\u03bd \u03ba\u03b1\u03b9 \u03bf\u03b9 \u03b4\u03cd\u03bf \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2.<\/p>\n<h2>\u03a3\u03c5\u03bc\u03c0\u03ad\u03c1\u03b1\u03c3\u03bc\u03b1:<\/h2>\n<p> \u00ab<br \/>\n\u00bb \u0397 \u03c3\u03c5\u03bd\u03ad\u03bd\u03c9\u03c3\u03b7 \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03c9\u03bd \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03b4\u03cd\u03c3\u03ba\u03bf\u03bb\u03b7, \u03b1\u03c1\u03ba\u03b5\u03af \u03bd\u03b1 \u03c3\u03c4\u03b1\u03bc\u03b1\u03c4\u03ae\u03c3\u03b5\u03c4\u03b5 \u03bd\u03b1 \u03c4\u03b7\u03bd \u03b1\u03bd\u03c4\u03b9\u03bc\u03b5\u03c4\u03c9\u03c0\u03af\u03b6\u03b5\u03c4\u03b5 \u03c9\u03c2 \u03ad\u03bd\u03b1 \u03b5\u03bd\u03b9\u03b1\u03af\u03bf \u03c0\u03c1\u03cc\u03b2\u03bb\u03b7\u03bc\u03b1. \u03a1\u03c9\u03c4\u03ae\u03c3\u03c4\u03b5 \u03c0\u03c1\u03ce\u03c4\u03b1 \u03c4\u03bf \u03b5\u03be\u03ae\u03c2: \u03c0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03b5\u03c0\u03b1\u03bd\u03b1\u03bb\u03b1\u03bc\u03b2\u03b1\u03bd\u03cc\u03bc\u03b5\u03bd\u03b5\u03c2 \u03b5\u03b3\u03b3\u03c1\u03b1\u03c6\u03ad\u03c2 \u03ae \u03b3\u03b9\u03b1 \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03b5\u03c2 \u03af\u03b4\u03b9\u03c9\u03bd \u03b1\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ce\u03bd; \u03a7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03c4\u03b5 \u03c4\u03b7\u03bd \u03b5\u03bd\u03c4\u03bf\u03bb\u03ae \u00ab\u03a0\u03c1\u03bf\u03c3\u03b8\u03ae\u03ba\u03b7\u00bb (Append) \u03bc\u03b5 \u03c4\u03bf Power Query \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03c0\u03c1\u03ce\u03c4\u03b7 \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7, \u03c4\u03b9\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 XLOOKUP \u03ae INDEX\/MATCH \u03b3\u03b9\u03b1 \u03c4\u03b7 \u03b4\u03b5\u03cd\u03c4\u03b5\u03c1\u03b7, \u03ba\u03b1\u03b9 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u00ab\u03a3\u03c5\u03b3\u03ba\u03ad\u03bd\u03c4\u03c1\u03c9\u03c3\u03b7\u00bb (Consolidate) \u03cc\u03c4\u03b1\u03bd \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c3\u03c4\u03b5 \u03bc\u03cc\u03bd\u03bf \u03c4\u03b1 \u03c3\u03cd\u03bd\u03bf\u03bb\u03b1. \u038c\u03c4\u03b1\u03bd \u03c3\u03c5\u03bd\u03b4\u03c5\u03ac\u03b6\u03b5\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c3\u03c4\u03bf Excel, \u03c0\u03c1\u03ce\u03c4\u03b1 \u03b1\u03bd\u03b1\u03bb\u03cd\u03c3\u03c4\u03b5 \u03c4\u03bf \u03c0\u03c1\u03cc\u03b2\u03bb\u03b7\u03bc\u03b1 \u03ba\u03b1\u03b9 \u03bc\u03b5\u03c4\u03ac \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03ae\u03c3\u03c4\u03b5 \u03c4\u03b7 \u03bb\u03cd\u03c3\u03b7. \u0391\u03c5\u03c4\u03ae \u03b7 \u03c3\u03b5\u03b9\u03c1\u03ac \u03b5\u03bd\u03b5\u03c1\u03b3\u03b5\u03b9\u03ce\u03bd \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03b5\u03be\u03bf\u03b9\u03ba\u03bf\u03bd\u03bf\u03bc\u03ae\u03c3\u03b5\u03b9 \u03c0\u03bf\u03bb\u03cd \u03c7\u03c1\u03cc\u03bd\u03bf.<\/p>\n<div class=\"pb-cta\" style=\"background: linear-gradient(160deg,#0f1032 0%,#1e1b4b 45%,#3730a3 100%); border-radius: 18px; padding: 40px 32px; margin: 36px 0; text-align: center;\">\n<div style=\"display: inline-block; color: #c7d2fe; font-size: 11px; font-weight: bold; letter-spacing: 0.08em; text-transform: uppercase; padding: 6px 14px; border-radius: 999px; margin: 0 0 16px;\">\ud83d\ude80 \u0395\u03c0\u03b9\u03c4\u03b1\u03c7\u03cd\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7\u03bd \u03b1\u03bd\u03ac\u03c0\u03c4\u03c5\u03be\u03ae \u03c3\u03b1\u03c2<\/div>\n<div style=\"font-size: 26px; line-height: 1.25; font-weight: 800; color: #ffffff; margin: 0 0 10px;\">\u0391\u03c0\u03bf\u03ba\u03c4\u03ae\u03c3\u03c4\u03b5 \u03c4\u03bf \u03b3\u03bd\u03ae\u03c3\u03b9\u03bf Office \u03c7\u03c9\u03c1\u03af\u03c2 \u03bd\u03b1 \u03c0\u03bb\u03b7\u03c1\u03ce\u03c3\u03b5\u03c4\u03b5 \u03c5\u03c0\u03b5\u03c1\u03b2\u03bf\u03bb\u03b9\u03ba\u03ac<\/div>\n<div style=\"font-size: 15px; line-height: 1.5; color: #c7d2fe; margin: 0 0 22px; max-width: 640px;\">\u03a7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03c4\u03b5 \u03c4\u03bf Power Query \u03ba\u03b1\u03b9 \u03c4\u03bf XLOOKUP \u03c3\u03b5 \u03ad\u03bd\u03b1 Excel \u03bc\u03b5 \u03c0\u03bb\u03ae\u03c1\u03b7 \u03ac\u03b4\u03b5\u03b9\u03b1 \u03c7\u03c1\u03ae\u03c3\u03b7\u03c2, \u03c0\u03bf\u03c5 \u03ad\u03c7\u03b5\u03b9 \u03b5\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03b9\u03b7\u03b8\u03b5\u03af \u03bc\u03b5 \u03bd\u03cc\u03bc\u03b9\u03bc\u03bf \u03c4\u03c1\u03cc\u03c0\u03bf.<\/div>\n<p><a style=\"display: inline-block; background: #4f46e5; color: #ffffff; font-size: 16px; font-weight: bold; text-decoration: none; padding: 15px 32px; border-radius: 999px;\" href=\"https:\/\/keyfy.com\/el\/\">\u0394\u03b5\u03af\u03c4\u03b5 \u03c4\u03bf\u03c5\u03c2 \u03b3\u03bd\u03ae\u03c3\u03b9\u03bf\u03c5\u03c2 \u03ba\u03c9\u03b4\u03b9\u03ba\u03bf\u03cd\u03c2 \u03b5\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7\u03c2 \u03c4\u03bf\u03c5 Office \u2192<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u039c\u03ac\u03b8\u03b5\u03c4\u03b5 \u03c0\u03ce\u03c2 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03c5\u03ac\u03b6\u03b5\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03b4\u03cd\u03bf \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c3\u03c4\u03bf Excel \u03bc\u03b5 \u03c4\u03bf\u03bd \u03c3\u03c9\u03c3\u03c4\u03cc \u03c4\u03c1\u03cc\u03c0\u03bf. \u03a0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c3\u03c4\u03b5 \u03c3\u03b5\u03b9\u03c1\u03ad\u03c2 \u03bc\u03b5 \u03c4\u03bf Power Query \u03ae \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03af\u03c3\u03c4\u03b5 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03bc\u03b5 \u03c4\u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 XLOOKUP \u2014 \u03b7 \u03bc\u03ad\u03b8\u03bf\u03b4\u03bf\u03c2 \u03b5\u03be\u03b1\u03c1\u03c4\u03ac\u03c4\u03b1\u03b9 \u03b1\u03c0\u03cc \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b1\u03c2.<\/p>\n","protected":false},"author":1483,"featured_media":38863,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_glsr_average":0,"_glsr_ranking":0,"_glsr_reviews":0,"footnotes":""},"categories":[363,370],"tags":[],"class_list":["post-38861","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-363","category-370"],"acf":[],"_links":{"self":[{"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/posts\/38861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/users\/1483"}],"replies":[{"embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/comments?post=38861"}],"version-history":[{"count":0,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/posts\/38861\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/media\/38863"}],"wp:attachment":[{"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/media?parent=38861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/categories?post=38861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/keyfy.com\/el\/wp-json\/wp\/v2\/tags?post=38861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}