{"id":93040,"date":"2025-03-12T14:36:37","date_gmt":"2025-03-12T05:36:37","guid":{"rendered":"https:\/\/www.excel-no-mori-blog.jp\/?p=93040"},"modified":"2025-02-02T21:09:00","modified_gmt":"2025-02-02T12:09:00","slug":"11-94","status":"publish","type":"post","link":"https:\/\/www.excel-no-mori-blog.jp\/?p=93040","title":{"rendered":"\u3010\u30a8\u30af\u30bb\u30eb\u5165\u9580\u3011\u30d1\u30ef\u30fc\u30af\u30a8\u30ea(PowerQuery)\u3068\u306f\uff1f\u30c7\u30fc\u30bf\u51e6\u7406\u306e\u81ea\u52d5\u5316\u3067\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u3092\u7d50\u5408\uff01"},"content":{"rendered":"\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30a8\u30af\u30bb\u30eb\u306e<span class=\"st-mymarker-s\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea<\/span>(PowerQuery)\u306f\u3001<strong><span class=\"st-mymarker-s\">\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u81ea\u52d5\u5316<\/span><\/strong>\u3059\u308b\u306e\u306b\u975e\u5e38\u306b\u5f79\u7acb\u3064\u6a5f\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">Excel2016\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304b\u3089\u6a19\u6e96\u642d\u8f09\u3055\u308c\u305f\u6a5f\u80fd\u3067\u3059\u304c\u3001\u307e\u3060\u8a8d\u77e5\u5ea6\u306f\u4f4e\u3044\u307e\u307e\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3057\u304b\u3057\u3001\u3053\u306e\u6a5f\u80fd\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3092\u7406\u89e3\u3057\u3066\u304a\u304f\u3060\u3051\u3067\u3001\u81ea\u52d5\u5316\u3067\u304d\u308bExcel\u51e6\u7406\u304c\u6570\u591a\u304f\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30a8\u30af\u30bb\u30eb\u306e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u5165\u9580\u7de8\u3068\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u5185\u5bb9\u3092\u304a\u5c4a\u3051\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-st-blocks-my-box st-mybox has-title\" style=\"background-color:#fff;border-color:#757575\"><p class=\"st-mybox-title\" style=\"color:#424242;font-weight:bold;text-shadow:#fff 3px 0px 0px, #fff 2.83487px .981584px 0px, #fff 2.35766px 1.85511px 0px, #fff 1.62091px 2.52441px 0px, #fff .705713px 2.91581px 0px, #fff -0.287171px 2.98622px 0px, #fff -1.24844px 2.72789px 0px, #fff -2.07227px 2.16926px 0px, #fff -2.66798px 1.37182px 0px, #fff -2.96998px .42336px 0px, #fff -2.94502px -0.571704px 0px, #fff -2.59586px -1.50383px 0px, #fff -1.96093px -2.27041px 0px, #fff -1.11013px -2.78704px 0px, #fff -0.137119px -2.99686px 0px, #fff .850987px -2.87677px 0px, #fff 1.74541px -2.43999px 0px, #fff 2.44769px -1.73459px 0px, #fff 2.88051px -0.838246px 0px;background:linear-gradient(0deg, #fff 0%, #fff 55%, rgba(0, 0, 0, 0) 55%, rgba(0, 0, 0, 0) 100%)\"><i class=\"st-fa st-svg-check-circle st-css-no\" aria-hidden=\"\"><\/i>\u3053\u306e\u8a18\u4e8b\u3067\u5b66\u7fd2\u3067\u304d\u308b\u3053\u3068<\/p><div class=\"st-in-mybox\">\n<p>\uff11\uff0e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea(PowerQuery)\u3068\u306f\uff1f<\/p>\n\n\n\n<p>\uff12\uff0e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u51fa\u6765\u308b\u3053\u3068<\/p>\n\n\n\n<p>\uff13\uff0e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u306e\u30a4\u30e1\u30fc\u30b8<\/p>\n\n\n\n<p>\uff14\uff0e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u3092\uff14\u3064\u7d39\u4ecb<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"st-kaiwa-box clearfix wp-block-st-blocks-st-kaiwa kaiwaicon3\">\r\n\t<div class=\"st-kaiwa-area2\">\r\n\t\t<div class=\"st-kaiwa-hukidashi2\"><div class=\"st-kaiwa-hukidashi-content\">\n<p class=\"is-style-default\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u5165\u9580\u7528\u306e\u4e8b\u4f8b\u3092\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u3002\u8ab0\u3067\u3082\u4f5c\u6210\u3067\u304d\u308b\u3088\u3046\u306b\u7d39\u4ecb\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u305c\u3072\u8a66\u3057\u3066\u307f\u3066\u4fbf\u5229\u3055\u3092\u5b9f\u611f\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<\/div><\/div>\r\n\t<\/div>\r\n\t<div class=\"st-kaiwa-face2\"><img decoding=\"async\" src=\"http:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2022\/09\/-1-e1663401258801.jpg\" alt=\"\u79c1\" width=\"100\" height=\"100\">\r\n\t\t<div class=\"st-kaiwa-face-name2\">\u79c1<\/div>\r\n\t<\/div>\r\n<\/div>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u30a8\u30af\u30bb\u30eb\u306e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea(PowerQuery)\u3068\u306f\uff1f<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea(PowerQuery)\u3068\u805e\u3044\u3066\u3082\u3001\u3044\u3063\u305f\u3044\u3069\u3093\u306a\u6a5f\u80fd\u306a\u306e\u304b\u30a4\u30e1\u30fc\u30b8\u3067\u304d\u306a\u3044\u4eba\u304c\u307b\u3068\u3093\u3069\u3067\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u307e\u305a\u306f\u3001\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3068\u306f\u4f55\u306a\u306e\u304b\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3068\u306f\u3001\u300e<span class=\"st-mymarker-s\">Microsoft Excel\u306b\u5099\u308f\u3063\u3066\u3044\u308b\u30c7\u30fc\u30bf\u51e6\u7406\u30c4\u30fc\u30eb\u306e1\u3064<\/span>\u300f\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306e\u6a5f\u80fd\u3092\u4f7f\u3046\u3068\u3001\u8907\u6570\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3093\u3067\u81ea\u52d5\u3067\u7d50\u5408\u3057\u305f\u308a\u3001\u5909\u5f62\u3055\u305b\u305f\u308a\u3001\u6570\u5f0f\u3092\u633f\u5165\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u3067\u3001\u5927\u5e45\u306a\u6642\u77ed\u306b\u3064\u306a\u304c\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306f\u3001Excel \u30d0\u30fc\u30b8\u30e7\u30f32016\u4ee5\u964d\u304b\u3089\u6a19\u6e96\u6a5f\u80fd\u3068\u3057\u3066\u642d\u8f09\u3055\u308c\u3001\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db\u300d\u304b\u3089\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-use-button.png\"><img decoding=\"async\" width=\"1240\" height=\"590\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-use-button.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea(PowerQuery)\u3092\u4f7f\u7528\u3059\u308b\u30dc\u30bf\u30f3\" class=\"wp-image-93074\" style=\"width:476px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-use-button.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-use-button-400x190.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-use-button-768x365.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea(PowerQuery)\u3092\u4f7f\u7528\u3059\u308b\u30dc\u30bf\u30f3<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div class=\"st-kaiwa-box clearfix wp-block-st-blocks-st-kaiwa kaiwaicon3\">\r\n\t<div class=\"st-kaiwa-area2\">\r\n\t\t<div class=\"st-kaiwa-hukidashi2\"><div class=\"st-kaiwa-hukidashi-content\">\n<p class=\"is-style-default\">CSV\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u308a\u8fbc\u3080\u969b\u306b\u3001\u77e5\u3089\u305a\u77e5\u3089\u305a\u306e\u3046\u3061\u306b\u4f7f\u3063\u305f\u3053\u3068\u304c\u3042\u308b\u4eba\u3082\u3044\u308b\u304b\u3082\u306d<\/p>\n<\/div><\/div>\r\n\t<\/div>\r\n\t<div class=\"st-kaiwa-face2\"><img decoding=\"async\" src=\"http:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2022\/09\/-1-e1663401258801.jpg\" alt=\"\u79c1\" width=\"100\" height=\"100\">\r\n\t\t<div class=\"st-kaiwa-face-name2\">\u79c1<\/div>\r\n\t<\/div>\r\n<\/div>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u51fa\u6765\u308b\u3053\u3068<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306f\u3001VBA(\u30de\u30af\u30ed)\u3068\u306f\u7570\u306a\u308a\u3001\u30ed\u30fc\u30b3\u30fc\u30c9\u3067\u4f7f\u7528\u3067\u304d\u308b\u306e\u304c\u30e1\u30ea\u30c3\u30c8\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3064\u307e\u308a\u3001<span class=\"st-mymarker-s\">\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u306e\u77e5\u8b58\u304c\u306a\u304f\u3066\u3082\u3001\u30c7\u30fc\u30bf\u51e6\u7406\u306e\u81ea\u52d5\u5316\u3092\u884c\u3048\u308b\u4fbf\u5229\u306a\u30c4\u30fc\u30eb<\/span>\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u53b3\u5bc6\u306b\u306f\u3001M\u8a00\u8a9e\u3068\u3044\u3046\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u9ad8\u5ea6\u306a\u30c7\u30fc\u30bf\u51e6\u7406\u306e\u81ea\u52d5\u5316\u3092\u884c\u3046\u5834\u5408\u306f\u3001M\u8a00\u8a9e\u3092\u53d6\u5f97\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3057\u304b\u3057\u3001\u7c21\u5358\u306a\u30c7\u30fc\u30bf\u51e6\u7406\u3067\u3042\u308c\u3070\u3001\u3060\u308c\u3067\u3082\u7c21\u5358\u306b\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u51e6\u7406\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\uff01<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u6d3b\u7528\u3059\u308c\u3070\u3001\u4ee5\u4e0b\u306e\u4f5c\u696d\u3092\u884c\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list is-style-st-timeline-count has-st-border has-st-solid-border has-st-thick-border-width\">\n<li>Excel\u3084CSV\u3001PDF\u306a\u3069\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3067\u304d\u308b<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(\u30a2\u30af\u30bb\u30b9\u3001Oracle\u306a\u3069)\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3067\u304d\u308b<\/li>\n\n\n\n<li>\u30af\u30e9\u30a6\u30c9\u30b5\u30fc\u30d3\u30b9(SharePoint\u306a\u3069)\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3067\u304d\u308b<\/li>\n\n\n\n<li>\u53d6\u308a\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u306e\u6574\u5f62\u3084\u52a0\u5de5\u304c\u3067\u304d\u308b<\/li>\n\n\n\n<li>\u53d6\u308a\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u306e\u8868\u793a\u5f62\u5f0f\u3092\u65e5\u4ed8\u3084\u6587\u5b57\u5217\u306a\u3069\u306b\u5909\u63db\u3067\u304d\u308b<\/li>\n\n\n\n<li>\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664\u3057\u305f\u308a\u3001\u4e26\u3073\u66ff\u3048\u3092\u884c\u3048\u308b<\/li>\n\n\n\n<li>\u5217\u3092\u8ffd\u52a0\u3057\u3066\u5408\u8a08\u306a\u3069\u306e\u6570\u5f0f\u3092\u633f\u5165\u3059\u308b<\/li>\n\n\n\n<li>\u8907\u6570\u306e\u30c7\u30fc\u30bf\u3092\u7d50\u5408\u3067\u304d\u308b<\/li>\n\n\n\n<li>\u30d1\u30ef\u30fc\u30d4\u30dc\u30c3\u30c8\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3068\u3001\u9ad8\u5ea6\u306a\u96c6\u8a08\u3084\u5206\u6790\u304c\u884c\u3048\u308b<\/li>\n\n\n\n<li><span class=\"st-mymarker-s\">\u300c\u66f4\u65b0\u300d\u30dc\u30bf\u30f3<\/span>\u3092\u62bc\u3059\u3060\u3051\u3067\u3001\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3001\u52a0\u5de5\u3001\u51fa\u529b\u3092<span class=\"st-mymarker-s\">\u81ea\u52d5\u3067\u884c\u3048\u308b<\/span><\/li>\n<\/ul>\n\n\n\n<div style=\"height:41px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u4e00\u756a\u306e\u30e1\u30ea\u30c3\u30c8\u306f\u300110\u9805\u306e\u300c\u66f4\u65b0\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3059\u3060\u3051\u3067\u3001\u81ea\u52d5\u3067\u30c7\u30fc\u30bf\u3092\u52a0\u5de5\u3067\u304d\u308b\u70b9\u306b\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u3066\u3001\u4efb\u610f\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u4fdd\u7ba1\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3001\u52a0\u5de5\u304c\u7d42\u308f\u3063\u305f\u3089Excel\u30d5\u30a1\u30a4\u30eb\u306b\u51fa\u529b\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eee\u306b\u3001\u53d6\u5f97\u3057\u305f<span class=\"st-mymarker-s\">\u5143\u30c7\u30fc\u30bf\u306e\u5024\u3092\u5909\u66f4<\/span>\u3057\u3066\u3082\u3001\u300c\u66f4\u65b0\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3059\u3060\u3051\u3067\u3001\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u51fa\u529b\u3057\u305f<span class=\"st-mymarker-s\">\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u3067\u66f4\u65b0<\/span>\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"st-kaiwa-box clearfix wp-block-st-blocks-st-kaiwa kaiwaicon3\">\r\n\t<div class=\"st-kaiwa-area2\">\r\n\t\t<div class=\"st-kaiwa-hukidashi2\"><div class=\"st-kaiwa-hukidashi-content\">\n<p class=\"is-style-default\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u3066\u306a\u304b\u3063\u305f\u3089\u3001\u6bce\u56de\u3001\u5143\u30c7\u30fc\u30bf\u3084\u6570\u5f0f\u3092\u8cbc\u308a\u3064\u3051\u76f4\u3059\u5fc5\u8981\u304c\u3042\u308b\u304b\u3089\u5927\u5909\u3060\u3051\u3069\u3001\u305d\u306e\u5fc5\u8981\u304c\u7121\u304f\u306a\u308b\u3088\u3002<\/p>\n<\/div><\/div>\r\n\t<\/div>\r\n\t<div class=\"st-kaiwa-face2\"><img decoding=\"async\" src=\"http:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2022\/09\/-1-e1663401258801.jpg\" alt=\"\u79c1\" width=\"100\" height=\"100\">\r\n\t\t<div class=\"st-kaiwa-face-name2\">\u79c1<\/div>\r\n\t<\/div>\r\n<\/div>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u306e\u30a4\u30e1\u30fc\u30b8<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u30c7\u30fc\u30bf\u51e6\u7406\u306e\u30a4\u30e1\u30fc\u30b8\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-step-image.png\"><img decoding=\"async\" width=\"1240\" height=\"809\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-step-image.png\" alt=\"PowerQuery(\u30d1\u30ef\u30fc\u30af\u30a8\u30ea)\u306e\u51e6\u7406\u306e\u30a4\u30e1\u30fc\u30b8\u56f3\" class=\"wp-image-93127\" style=\"width:532px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-step-image.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-step-image-400x261.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-step-image-768x501.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>PowerQuery(\u30d1\u30ef\u30fc\u30af\u30a8\u30ea)\u306e\u51e6\u7406\u306e\u30a4\u30e1\u30fc\u30b8\u56f3<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:56px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list is-style-st-timeline-count has-st-border has-st-solid-border has-st-thick-border-width\">\n<li><strong>\u30b9\u30c6\u30c3\u30d7\uff11\uff0e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b<\/strong><br>Excel\u30d5\u30a1\u30a4\u30eb\u3084CSV\u30d5\u30a1\u30a4\u30eb\u306a\u3069\u3092\u8aad\u307f\u8fbc\u3093\u3067\u3001PowerQuery\u306e\u51e6\u7406\u3092\u958b\u59cb\u3059\u308b\u3002\u8907\u6570\u306e\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3080\u3053\u3068\u304c\u53ef\u80fd\u3002<br><br><\/li>\n\n\n\n<li><strong>\u30b9\u30c6\u30c3\u30d7\uff12\uff0e\u30c7\u30fc\u30bf\u3092\u52a0\u5de5\u3059\u308b<\/strong><br>\u8907\u6570\u306e\u30c7\u30fc\u30bf\u306e\u7d50\u5408\u3084\u4e26\u3079\u66ff\u3048\u3001\u5217\u306e\u8ffd\u52a0\/\u524a\u9664\u3001\u6570\u5f0f\u306e\u633f\u5165\u306a\u3069\u3092\u884c\u3046<br><br><\/li>\n\n\n\n<li><strong>\u30b9\u30c6\u30c3\u30d7\uff13\uff0e\u30c7\u30fc\u30bf\u3092\u51fa\u529b\u3059\u308b<\/strong><br>Excel\u306e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u30c7\u30fc\u30bf\u3092\u51fa\u529b\u3059\u308b\u3002\u300c\u66f4\u65b0\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3059\u3053\u3068\u3067\u3001\u5143\u30c7\u30fc\u30bf\u306e\u5909\u66f4\u3092\u53cd\u6620\u3067\u304d\u308b<br><\/li>\n<\/ul>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u3010\u5165\u9580\u7de8\u3011\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u305d\u306e\uff11<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u308c\u3067\u306f\u5b9f\u969b\u306b\u30d1\u30ef\u30fc\u30af\u30a8\u30ea(PowerQuery)\u3092\u4f7f\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eca\u56de\u306f\u8aac\u660e\u7528\u306b\u3001\u8907\u6570\u306eExcel\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u3063\u3066\u3001\u300c<strong><span class=\"st-mymarker-s\">\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u3067\u7d50\u5408\u3057\u3066\u52a0\u5de5<\/span><\/strong>\u300d\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u96e3\u3057\u3044\u64cd\u4f5c\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u30b9\u30c6\u30c3\u30d7\uff10\u304b\u3089\u30b9\u30c6\u30c3\u30d7\uff14\u307e\u3067\u306e\u624b\u9806\u306b\u6cbf\u3063\u3066\u843d\u3061\u7740\u3044\u3066\u4f5c\u696d\u3059\u308c\u3070\u3001\uff11\uff15\u5206\u7a0b\u5ea6\u3067\u5b8c\u4e86\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u4fbf\u5229\u3055\u3092\u611f\u3058\u308b\u3053\u3068\u9593\u9055\u3044\u306a\u3044\u306e\u3067\u3001\u305c\u3072\u30c1\u30e3\u30ec\u30f3\u30b8\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"st-kaiwa-box clearfix wp-block-st-blocks-st-kaiwa kaiwaicon3\">\r\n\t<div class=\"st-kaiwa-area2\">\r\n\t\t<div class=\"st-kaiwa-hukidashi2\"><div class=\"st-kaiwa-hukidashi-content\">\n<p>\u7c21\u5358\u306a\u4f5c\u696d\u3060\u304b\u3089\u3001\u3060\u307e\u3055\u308c\u305f\u3068\u601d\u3063\u30661\u5ea6\u3067\u3044\u3044\u304b\u3089\u3084\u3063\u3066\u307f\u3066\uff01<\/p>\n<\/div><\/div>\r\n\t<\/div>\r\n\t<div class=\"st-kaiwa-face2\"><img decoding=\"async\" src=\"http:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2022\/09\/-1-e1663401258801.jpg\" alt=\"\u79c1\" width=\"100\" height=\"100\">\r\n\t\t<div class=\"st-kaiwa-face-name2\">\u79c1<\/div>\r\n\t<\/div>\r\n<\/div>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">PowerQuery\/\u30b9\u30c6\u30c3\u30d7\uff10\uff0e\u5143\u30c7\u30fc\u30bf\u306e\u6e96\u5099<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30b9\u30c6\u30c3\u30d70\u3067\u306f\u3001\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3046\u305f\u3081\u306e\u5143\u30c7\u30fc\u30bf\u3092\uff12\u3064\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"is-style-default\"><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff11\uff0e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306b\u53d6\u308a\u8fbc\u3080\u5143\u30c7\u30fc\u30bf\u300c\u4ed5\u5165\u5148\u300d\u3092\u6e96\u5099<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u307e\u305a\u306f\u3001\u4e0b\u306e\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8\u306e\u3088\u3046\u306a<span class=\"st-mymarker-s\">\u300c\u4ed5\u5165\u5148\u300d\u30de\u30b9\u30bf<\/span>\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u300c\u5546\u54c1\u30b3\u30fc\u30c9\u300d\u3054\u3068\u306e\u300c\u5546\u54c1\u540d\u300d\u300c\u751f\u7523\u5730\u300d\u300c\u30ab\u30c6\u30b4\u30ea\u300d\u3092\u8868\u306b\u307e\u3068\u3081\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-fisrst.png\"><img decoding=\"async\" width=\"1240\" height=\"1213\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-fisrst.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306b\u4f7f\u7528\u3059\u308b\u5143\u30c7\u30fc\u30bf\u300c\u4ed5\u5165\u5148\u300d\" class=\"wp-image-93199\" style=\"width:398px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-fisrst.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-fisrst-400x391.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-fisrst-768x751.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306b\u4f7f\u7528\u3059\u308b\u5143\u30c7\u30fc\u30bf\u300c\u4ed5\u5165\u5148\u300d<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"is-style-default\"><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff12\uff0e<span style=\"text-decoration: underline;\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306b\u53d6\u308a\u8fbc\u3080\u5143\u30c7\u30fc\u30bf\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u3092\u6e96\u5099<\/strong><\/span><\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u65b0\u898f\u306bExcel\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3044\u3066\u3001\u4e0b\u306e\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8\u306e\u3088\u3046\u306a<span class=\"st-mymarker-s\">\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u30c7\u30fc\u30bf<\/span>\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u30c7\u30fc\u30bf\u306b\u306f\u3001\u300c\u4ed5\u5165\u5148\u300d\u30de\u30b9\u30bf\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u4f7f\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-second.png\"><img decoding=\"async\" width=\"1133\" height=\"1240\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-second.png\" alt=\"\" class=\"wp-image-93206\" style=\"width:390px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-second.png 1133w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-second-365x400.png 365w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-second-768x841.png 768w\" sizes=\"(max-width: 1133px) 100vw, 1133px\" \/><\/a><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff13\uff0e\u4efb\u610f\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u4fdd\u5b58<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u624b\u9806\uff11\uff0c\uff12\u3067\u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u3092\u4efb\u610f\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u4fdd\u5b58\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-storage-basic-data.png\"><img decoding=\"async\" width=\"1240\" height=\"531\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-storage-basic-data.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u5143\u30c7\u30fc\u30bf\u3092\u4fdd\u5b58\" class=\"wp-image-93210\" style=\"width:452px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-storage-basic-data.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-storage-basic-data-400x171.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-storage-basic-data-768x329.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u5143\u30c7\u30fc\u30bf\u3092\u4fdd\u5b58<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u306e\u6e96\u5099\u306f\u4ee5\u4e0a\u3067\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">PowerQuery\/\u30b9\u30c6\u30c3\u30d7\uff11\uff0e\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">STEP1\u3067\u306f\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u3001STEP0\u3067\u4f5c\u6210\u3057\u305f\uff12\u3064\u306e\u5143\u30c7\u30fc\u30bf\u3092Excel\u306b\u8aad\u307f\u8fbc\u307f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306b\u300c\u8aad\u307f\u8fbc\u3080\u300d\u3068\u306f\u3001\u300c\u53d6\u308a\u8fbc\u3080\u300d\u300c\u53d6\u5f97\u3059\u308b\u300d\u3068\u540c\u7fa9\u3060\u3068\u601d\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff11\uff0e\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u300d\u3092\u9078\u629e<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u65b0\u898f\u306bExcel\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3044\u3066\u3001\u300c\u30c7\u30fc\u30bf\u300d\u30bf\u30d6\u306e\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u300d\u30b3\u30de\u30f3\u30c9\u3092\u9078\u629e\u3057\u3001\u300c\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u300d\u306e<strong>\u300cExcel\u30d6\u30c3\u30af\u304b\u3089\u300d\u3092\u9078\u629e<\/strong>\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-data-acquisition.png\"><img decoding=\"async\" width=\"1240\" height=\"830\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-data-acquisition.png\" alt=\"\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u300d\u304b\u3089Excel\u30d6\u30c3\u30af\u3092\u8aad\u307f\u8fbc\u3080\" class=\"wp-image-93221\" style=\"width:416px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-data-acquisition.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-data-acquisition-400x268.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-data-acquisition-768x514.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u300d\u304b\u3089Excel\u30d6\u30c3\u30af\u3092\u8aad\u307f\u8fbc\u3080<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff12\uff0e\u5143\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u30b9\u30c6\u30c3\u30d70\u3067\u4f5c\u6210\u3057\u305f\u300c\u4ed5\u5165\u5148\u300d\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e\u3057\u3066(\u56f32)\u3001\u300c\u30a4\u30f3\u30dd\u30fc\u30c8\u300d\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044(\u56f33)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-import-basic-data.png\"><img decoding=\"async\" width=\"1240\" height=\"735\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-import-basic-data.png\" alt=\"\u300c\u4ed5\u5165\u5148\u300d\u30d5\u30a1\u30a4\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\" class=\"wp-image-93229\" style=\"width:578px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-import-basic-data.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-import-basic-data-400x237.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-import-basic-data-768x455.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300c\u4ed5\u5165\u5148\u300d\u30d5\u30a1\u30a4\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff13\uff0e\u5143\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u30ca\u30d3\u30b2\u30fc\u30bf\u30fc\u300d\u753b\u9762\u304c\u958b\u304d\u307e\u3059\u3002\u753b\u9762\u306e\u5de6\u5074\u306b\u8aad\u307f\u8fbc\u3093\u3060\u300c\u4ed5\u5165\u5148\u300d\u30d5\u30a1\u30a4\u30eb\u306e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u5bfe\u8c61\u306e\u30b7\u30fc\u30c8\u3092\u9078\u629e\u3057(\u56f34)\u3001\u300c\u8aad\u307f\u8fbc\u307f\u300d\u3092\u62bc\u3057\u307e\u3059(\u56f35)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-navigator.png\"><img decoding=\"async\" width=\"1240\" height=\"761\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-navigator.png\" alt=\"\u30ca\u30d3\u30b2\u30fc\u30bf\u30fc\u753b\u9762\u3067\u8aad\u307f\u8fbc\u307f\u30b7\u30fc\u30c8\u3092\u9078\u629e\" class=\"wp-image-93234\" style=\"width:600px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-navigator.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-navigator-400x245.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-navigator-768x471.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30ca\u30d3\u30b2\u30fc\u30bf\u30fc\u753b\u9762\u3067\u8aad\u307f\u8fbc\u307f\u30b7\u30fc\u30c8\u3092\u9078\u629e<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff14\uff0e\u5143\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u4ed5\u5165\u5148\u300d\u306e\u30c7\u30fc\u30bf\u304cExcel\u306b\u53d6\u308a\u8fbc\u307e\u308c\u307e\u3059\u3002\u753b\u9762\u53f3\u5074\u306b\u300c\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\u300d\u753b\u9762\u306b\u53d6\u308a\u8fbc\u3093\u3060<strong><span class=\"st-mymarker-s\">\u30af\u30a8\u30ea<\/span><\/strong>(\u203b)\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-check has-background\" style=\"background-color:#d3ecfd\">\u203b\u300c<strong>\u30af\u30a8\u30ea<\/strong>\u300d\u3068\u306f\u30fb\u30fb\u53d6\u308a\u8fbc\u3093\u3060Excel\u30d5\u30a1\u30a4\u30eb\u306b\u8981\u6c42\u3092\u9001\u4fe1\u3059\u308b\u547d\u4ee4\u6587\u306e\u3053\u3068<\/p>\n\n\n\n<div style=\"height:43px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066(\u56f36)\u3001\u53f3\u30af\u30ea\u30c3\u30af\u30e1\u30cb\u30e5\u30fc\u306e\u300c\u540d\u524d\u3068\u5909\u66f4\u300d\u304b\u3089\u540d\u524d\u3092\u300c\u4ed5\u5165\u5148\u300d\u306b\u5909\u66f4\u3057\u307e\u3059(\u56f37\u30018)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-name-change-1.png\"><img decoding=\"async\" width=\"1240\" height=\"655\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-name-change-1.png\" alt=\"\u30af\u30a8\u30ea\u306e\u540d\u524d\u3092\u5909\u66f4\" class=\"wp-image-93332\" style=\"width:558px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-name-change-1.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-name-change-1-400x211.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-name-change-1-768x406.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30af\u30a8\u30ea\u306e\u540d\u524d\u3092\u5909\u66f4<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u753b\u9762\u53f3\u5074\u306b\u300c\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001\u300c\u30c7\u30fc\u30bf\u300d\u30bf\u30d6\u306e<strong>\u300c\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\u300d\u3092\u30af\u30ea\u30c3\u30af<\/strong>\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff15\uff0e\u300c\u898b\u51fa\u3057\u300d\u3092\u78ba\u8a8d<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u8aad\u307f\u8fbc\u3093\u3060\u4ed5\u5165\u5148\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b\u3068\u3001\u898b\u51fa\u3057\u884c\u304c\u300ccolumn1\u300d\u300ccolumn2\u300d\u300ccolumn3\u300d\u300ccolumn4\u300d\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u308a\u8fbc\u3093\u3060\u969b\u3001\u898b\u51fa\u3057\u884c\u3092\u6b63\u3057\u304f\u5224\u65ad\u3067\u304d\u306a\u304b\u3063\u305f\u305f\u3081\u306b\u767a\u751f\u3057\u305f\u73fe\u8c61\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u898b\u51fa\u3057\u884c\u3092\u7de8\u96c6\u3059\u308b\u305f\u3081\u306b\u3001\u5bfe\u8c61\u306e<strong><span class=\"st-mymarker-s\">\u30af\u30a8\u30ea\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af<\/span><\/strong>\u3057\u307e\u3059(\u56f39)\u3002\u203b\u4fee\u6b63\u3059\u308b\u5fc5\u8981\u304c\u7121\u3044\u5834\u5408\u306f\u3001\u624b\u9806\uff19\u304b\u3089\u4f5c\u696d\u3092\u958b\u59cb\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-row.png\"><img decoding=\"async\" width=\"1240\" height=\"648\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-row.png\" alt=\"\u898b\u51fa\u3057\u3092\u4fee\u6b63\u3059\u308b\u305f\u3081\u30af\u30a8\u30ea\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\" class=\"wp-image-93254\" style=\"width:612px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-row.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-row-400x209.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-row-768x401.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u898b\u51fa\u3057\u3092\u4fee\u6b63\u3059\u308b\u305f\u3081\u30af\u30a8\u30ea\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff16\uff0e\u300c\u30d8\u30c3\u30c0\u30fc\u300d\u3092\u5909\u63db<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300cPower Query \u30a8\u30c7\u30a3\u30bf\u30fc\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u300c\u5909\u63db\u300d\u30bf\u30d6\u306e\u300c<strong><span class=\"st-mymarker-s\">\uff11\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u4f7f\u7528<\/span><\/strong>\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u307e\u3059(\u56f310)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change.png\"><img decoding=\"async\" width=\"1240\" height=\"624\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change.png\" alt=\"\uff11\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u306b\u4f7f\u7528\" class=\"wp-image-93268\" style=\"width:568px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change-400x201.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change-768x386.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\uff11\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u306b\u4f7f\u7528<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff17\uff0e\u300c\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080\u300d\u3092\u62bc\u3059<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\uff11\u884c\u76ee\u304c\u30d8\u30c3\u30c0\u30fc\u306b\u5909\u308f\u3063\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u78ba\u8a8d\u3067\u304d\u305f\u3089\u3001\u300c\u30db\u30fc\u30e0\u300d\u30bf\u30d6\u306e\u300c\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u3001\u30a8\u30c7\u30a3\u30bf\u30fc\u753b\u9762\u3092\u9589\u3058\u307e\u3059(\u56f311)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change-result.png\"><img decoding=\"async\" width=\"1240\" height=\"578\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change-result.png\" alt=\"PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080\" class=\"wp-image-93274\" style=\"width:620px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change-result.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change-result-400x186.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-change-result-768x358.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff18\uff0e\u300c\u30d8\u30c3\u30c0\u30fc\u300d\u3092\u78ba\u8a8d<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u5143\u306e\u30a8\u30af\u30bb\u30eb\u753b\u9762\u306b\u623b\u308a\u307e\u3059\u3002\u4e0b\u306e\u3088\u3046\u306b\u3001\u30d8\u30c3\u30c0\u30fc(\u898b\u51fa\u3057)\u304c\u5909\u66f4\u3055\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-completed.png\"><img decoding=\"async\" width=\"1240\" height=\"575\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-completed.png\" alt=\"\u898b\u51fa\u3057\u884c\u306e\u5909\u66f4\u3092\u78ba\u8a8d\" class=\"wp-image-93278\" style=\"width:596px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-completed.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-completed-400x185.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-header-completed-768x356.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u898b\u51fa\u3057\u884c\u306e\u5909\u66f4\u3092\u78ba\u8a8d<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff19\uff0e\u300c\u30d8\u30c3\u30c0\u30fc\u300d\u3092\u78ba\u8a8d<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4ee5\u4e0a\u3067\u300c\u4ed5\u5165\u5148\u300d\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f\u306f\u5b8c\u4e86\u3067\u3059\u3002\u7d9a\u3044\u3066\u3001\u540c\u3058Excel\u30d5\u30a1\u30a4\u30eb\u4e0a\u3067\u3001\u30b9\u30c6\u30c3\u30d70\u3067\u4f5c\u6210\u3057\u305f<span class=\"st-mymarker-s\"><strong>\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u30a8\u30af\u30bb\u30eb\u3082\u8aad\u307f\u8fbc\u307f<\/strong>\u307e\u3059<\/span>\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u624b\u9806\uff11\uff5e\u624b\u98068\u3092\u7e70\u308a\u8fd4\u3057\u3066\u3001\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u30c7\u30fc\u30bf\u3082\u8aad\u307f\u8fbc\u3093\u3067\u304f\u3060\u3055\u3044(\u56f312)\u3002\uff12\u3064\u306e\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3093\u3060\u3089\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306e\u540d\u524d\u3082\u5206\u304b\u308a\u3084\u3059\u3044\u540d\u79f0\u306b\u5909\u66f4\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046(\u56f313)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-second-data-acquisition-1.png\"><img decoding=\"async\" width=\"1240\" height=\"656\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-second-data-acquisition-1.png\" alt=\"\uff12\u3064\u76ee\u306e\u5143\u30c7\u30fc\u30bf\u3092\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u8aad\u307f\u8fbc\u3080\" class=\"wp-image-93308\" style=\"width:660px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-second-data-acquisition-1.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-second-data-acquisition-1-400x212.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-second-data-acquisition-1-768x406.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\uff12\u3064\u76ee\u306e\u5143\u30c7\u30fc\u30bf\u3092\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u8aad\u307f\u8fbc\u3080<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:59px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff11\uff10\uff0e\u540d\u524d\u3092\u4ed8\u3051\u3066\u4fdd\u5b58\u3057\u3066\u9589\u3058\u308b<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4ee5\u4e0a\u3067\u30b9\u30c6\u30c3\u30d7\uff11\u306e\u300c\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u8aad\u307f\u8fbc\u307f\u300d\u306b\u95a2\u3059\u308b\u4f5c\u696d\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u8aad\u307f\u8fbc\u3093\u3060Excel\u30d6\u30c3\u30af\u306f\u540d\u524d\u3092\u4ed8\u3051\u3066\u4fdd\u5b58\u3057\u3066\u9589\u3058\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">PowerQuery\/\u30b9\u30c6\u30c3\u30d7\uff12\uff0e\uff12\u3064\u306eExcel\u30d6\u30c3\u30af\u3092\u7d50\u5408<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30b9\u30c6\u30c3\u30d72\u3067\u306f\u3001\u30b9\u30c6\u30c3\u30d71\u3067\u8aad\u307f\u8fbc\u3093\u3060\u300c\u4ed5\u5165\u5148\u300d\u3068\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u306e<strong><span class=\"st-mymarker-s\">\uff12\u3064\u306eExcel\u30d6\u30c3\u30af\u3092\u7d50\u5408<\/span><\/strong>\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff11\uff0eExcel\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3075\u305f\u305f\u3073\u3001Excel\u30d6\u30c3\u30af\u3092\u958b\u304d\u307e\u3059\u3002\u30ea\u30dc\u30f3\u306e\u4e0b\u306b\u300c\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u8b66\u544a\u300d\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u308b\u5834\u5408\u306f\u3001<strong>\u300c\u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u6709\u52b9\u5316\u300d\u3092\u30af\u30ea\u30c3\u30af<\/strong>\u3057\u3066\u304f\u3060\u3055\u3044(\u56f31)\u3002\u3053\u306e\u64cd\u4f5c\u3092\u884c\u308f\u306a\u3044\u3068\u3001\u5143\u30c7\u30fc\u30bf\u3068\u306e\u5916\u90e8\u9023\u643a\u304c\u884c\u308f\u308c\u307e\u305b\u3093\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-contents-enable.png\"><img decoding=\"async\" width=\"1240\" height=\"835\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-contents-enable.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306econtents\u306e\u6709\u52b9\u5316\" class=\"wp-image-93310\" style=\"width:480px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-contents-enable.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-contents-enable-400x269.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-contents-enable-768x517.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u6709\u52b9\u5316<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff12\uff0e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u8b66\u544a\u306e\u30e1\u30c3\u30bb\u30fc\u30b8<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4ee5\u4e0b\u306e\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8\u306e\u3088\u3046\u306a\u300c\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u8b66\u544a\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u5834\u5408\u306f\u3001\u300c\u306f\u3044\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-security-document.png\"><img decoding=\"async\" width=\"1240\" height=\"455\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-security-document.png\" alt=\"\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u8b66\u544a\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\" class=\"wp-image-93318\" style=\"width:482px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-security-document.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-security-document-400x147.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-security-document-768x282.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306e\u8b66\u544a\u306e\u30e1\u30c3\u30bb\u30fc\u30b8<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff13\uff0e\u300c\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\u300d\u3092\u30af\u30ea\u30c3\u30af<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u753b\u9762\u53f3\u5074\u306b\u300c\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001\u300c\u30c7\u30fc\u30bf\u300d\u30bf\u30d6\u306e<strong><span class=\"st-mymarker-s\">\u300c\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\u300d\u3092\u30af\u30ea\u30c3\u30af<\/span><\/strong>\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-connect-display.png\"><img decoding=\"async\" width=\"1240\" height=\"593\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-connect-display.png\" alt=\"\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\u3092\u518d\u8868\u793a\" class=\"wp-image-93324\" style=\"width:606px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-connect-display.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-connect-display-400x191.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-connect-display-768x367.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\u3092\u518d\u8868\u793a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff14\uff0e\u300c\u7d50\u5408\u300d\u3092\u30af\u30ea\u30c3\u30af<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u4ed5\u5165\u5148\u300d\u30c7\u30fc\u30bf\u306e\u4efb\u610f\u306e\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066(\u56f34)\u3001\u300c\u30af\u30a8\u30ea\u300d\u30bf\u30d6\u306e<strong><span class=\"st-mymarker-s\">\u300c\u7d50\u5408\u300d\u3092\u9078\u629e<\/span><\/strong>\u3057\u307e\u3059(\u56f35)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join.png\"><img decoding=\"async\" width=\"1240\" height=\"726\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u3092\u7d50\u5408\" class=\"wp-image-93340\" style=\"width:552px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-400x234.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-768x450.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u3092\u7d50\u5408<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff15\uff0e\u300c\u7d50\u5408\u306e\u7a2e\u985e\u300d\u3092\u6307\u5b9a<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u30de\u30fc\u30b8\u300d\u753b\u9762\u3067\u3001\u4e0a\u5074\u306e\u30c7\u30fc\u30bf\u3092\u300c\u4ed5\u5165\u5148\u300d\u3092\u9078\u629e\u3057\u307e\u3059(\u56f36)\u3002\u4e0b\u5074\u306e\u30c7\u30fc\u30bf\u306f\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u3092\u9078\u629e\u3057\u307e\u3059(\u56f37)\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6700\u4e0b\u90e8\u306e\u7d50\u5408\u306e\u7a2e\u985e\u306f\u3001\u300c\u5de6\u5916\u90e8(\u6700\u521d\u306e\u884c\u3059\u3079\u3066\u3001\u304a\u3088\u3073\uff12\u756a\u76ee\u306e\u884c\u306e\u3046\u3061\u4e00\u81f4\u3059\u308b\u3082\u306e\u300d\u3092\u9078\u629e\u3057\u307e\u3059(\u56f38)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-merge-step1.png\"><img decoding=\"async\" width=\"1240\" height=\"998\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-merge-step1.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u306e\u7d50\u5408\u306e\u7a2e\u985e\u3092\u6307\u5b9a\" class=\"wp-image-93344\" style=\"width:478px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-merge-step1.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-merge-step1-400x322.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-merge-step1-768x618.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u306e\u7d50\u5408\u306e\u7a2e\u985e\u3092\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff16\uff0e\u300c\u30ad\u30fc\u5217\u300d\u3092\u6307\u5b9a<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u7d50\u5408\u3059\u308b\u30ad\u30fc\u3068\u306a\u308b\u30ad\u30fc\u5217\u3092\u3057\u307e\u3059\u3002\u300c\u4ed5\u5165\u5148\u300d\u306e\u300c\u5546\u54c1\u30b3\u30fc\u30c9\u300d\u5217\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059(\u56f39)\u3002\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u306e\u300c\u5546\u54c1\u30b3\u30fc\u30c9\u300d\u5217\u3082\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059(\u56f310)\u3002\u9078\u629e\u3057\u305f\u3089\u3001\u53f3\u4e0b\u306e\u300cOK\u300d\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044(\u56f311)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-merge-key-column.png\"><img decoding=\"async\" width=\"1240\" height=\"1119\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-merge-key-column.png\" alt=\"\u7d50\u5408\u3059\u308b\u30ad\u30fc\u5217\u3092\u6307\u5b9a\" class=\"wp-image-93349\" style=\"width:450px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-merge-key-column.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-merge-key-column-400x361.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-merge-key-column-768x693.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7d50\u5408\u3059\u308b\u30ad\u30fc\u5217\u3092\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff17\uff0e\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u5217\u3092\u958b\u304f<\/strong><\/span><\/p>\n\n\n\n<p>\u300cPowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u300d\u304c\u958b\u304d\u307e\u3059\u3002\u300c\u4ed5\u5165\u5148\u300d\u306b\u7d50\u5408\u3055\u308c\u305f\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u5217\u3092\u78ba\u8a8d\u3057\u3001\u30d8\u30c3\u30c0\u30fc\u306e\u53f3\u5074\u306e\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044(\u56f312)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-join.png\"><img decoding=\"async\" width=\"1240\" height=\"553\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-join.png\" alt=\"\u7d50\u5408\u3055\u308c\u305f\u5f8c\u306ePowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\" class=\"wp-image-93355\" style=\"width:616px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-join.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-join-400x178.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-join-768x343.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7d50\u5408\u3055\u308c\u305f\u5f8c\u306ePowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff18\uff0e\u5c55\u958b\u3059\u308b\u5217\u3092\u9078\u629e\u3059\u308b<\/strong><\/span><\/p>\n\n\n\n<p>\u300c\u5546\u54c1\u30b3\u30fc\u30c9\u300d\u5217\u306f\u300c\u4ed5\u5165\u5148\u300d\u30c7\u30fc\u30bf\u304b\u3089\u53d6\u308a\u8fbc\u307e\u308c\u308b\u306e\u3067\u3001\u300c\u5546\u54c1\u30b3\u30fc\u30c9\u300d\u306e\u30c1\u30a7\u30c3\u30af\u3092\u5916\u3057\u307e\u3059(\u56f313)\u3002\u300c\u3082\u306e\u5217\u540d\u3092\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u3068\u3057\u3066\u4f7f\u7528\u3057\u307e\u3059\u300d\u306e\u30c1\u30a7\u30c3\u30af\u3082\u5916\u3057\u3066\u304f\u3060\u3055\u3044(\u56f314)\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u8a2d\u5b9a\u3057\u305f\u3089\u300cOK\u300d\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044(\u56f315)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-select.png\"><img decoding=\"async\" width=\"1240\" height=\"1018\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-select.png\" alt=\"\u7d50\u5408\u3057\u3066\u5c55\u958b\u3059\u308b\u5217\u3092\u9078\u629e\" class=\"wp-image-93359\" style=\"width:430px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-select.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-select-400x328.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-select-768x631.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7d50\u5408\u3057\u3066\u5c55\u958b\u3059\u308b\u5217\u3092\u9078\u629e<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff19\uff0ePowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u9589\u3058\u308b<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u30c7\u30fc\u30bf\u304c\u5c55\u958b\u3055\u308c\u307e\u3059\u3002\u300c\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u9589\u3058\u3066\u304f\u3060\u3055\u3044(\u56f316)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-result.png\"><img decoding=\"async\" width=\"1240\" height=\"603\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-result.png\" alt=\"PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u9589\u3058\u308b\" class=\"wp-image-93364\" style=\"width:656px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-result.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-result-400x195.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-expand-result-768x373.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u9589\u3058\u308b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff11\uff10\uff0e\u30af\u30a8\u30ea\u306e\u540d\u79f0\u3092\u5909\u66f4\u3059\u308b<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u4ed5\u5165\u5148\u300d\u3068\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u304c\u7d50\u5408\u3055\u308c\u305f\u30c7\u30fc\u30bf\u304c\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u306b\u5c55\u958b\u3055\u308c\u307e\u3059\u3002\u300c\u30af\u30a8\u30ea\u3068\u63a5\u7d9a\u300d\u753b\u9762\u306b\u7d50\u5408\u3057\u305f\u30af\u30a8\u30ea\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u53f3\u30af\u30ea\u30c3\u30af\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u540d\u524d\u3092\u300c\u7d50\u5408\u30c7\u30fc\u30bf\u300d\u306b\u5909\u66f4\u3057\u307e\u3059(\u56f317)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-completed.png\"><img decoding=\"async\" width=\"1240\" height=\"538\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-completed.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u8907\u6570\u30c7\u30fc\u30bf\u306e\u7d50\u5408\u304c\u5b8c\u4e86\" class=\"wp-image-93371\" style=\"width:688px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-completed.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-completed-400x174.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-completed-768x333.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u8907\u6570\u30c7\u30fc\u30bf\u306e\u7d50\u5408\u304c\u5b8c\u4e86<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u4ee5\u4e0a\u3067\u30b9\u30c6\u30c3\u30d7\uff12\u306e\u4f5c\u696d\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">PowerQuery\/\u30b9\u30c6\u30c3\u30d7\uff13\uff0e\u52a0\u5de5(\u5217\u306e\u633f\u5165\u3001\u4e26\u3079\u66ff\u3048\u3001\u30d5\u30a3\u30eb\u30bf\u30fc)<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30b9\u30c6\u30c3\u30d7\uff13\u3067\u306f\u3001<strong><span class=\"st-mymarker-s\">\u7d50\u5408\u3057\u305f\u30c7\u30fc\u30bf\u3092\u52a0\u5de5<\/span><\/strong>\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eca\u56de\u306f\u3001\u4ee5\u4e0b\u306e\uff13\u3064\u306e\u52a0\u5de5\u304c\u81ea\u52d5\u3067\u884c\u308f\u308c\u308b\u3088\u3046\u306b\u3001PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u7de8\u96c6\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-st-blocks-my-box st-mybox has-title\" style=\"background-color:#fff;border-color:#757575\"><p class=\"st-mybox-title\" style=\"color:#424242;font-weight:bold;text-shadow:#fff 3px 0px 0px, #fff 2.83487px .981584px 0px, #fff 2.35766px 1.85511px 0px, #fff 1.62091px 2.52441px 0px, #fff .705713px 2.91581px 0px, #fff -0.287171px 2.98622px 0px, #fff -1.24844px 2.72789px 0px, #fff -2.07227px 2.16926px 0px, #fff -2.66798px 1.37182px 0px, #fff -2.96998px .42336px 0px, #fff -2.94502px -0.571704px 0px, #fff -2.59586px -1.50383px 0px, #fff -1.96093px -2.27041px 0px, #fff -1.11013px -2.78704px 0px, #fff -0.137119px -2.99686px 0px, #fff .850987px -2.87677px 0px, #fff 1.74541px -2.43999px 0px, #fff 2.44769px -1.73459px 0px, #fff 2.88051px -0.838246px 0px;background:linear-gradient(0deg, #fff 0%, #fff 55%, rgba(0, 0, 0, 0) 55%, rgba(0, 0, 0, 0) 100%)\"><i class=\"st-fa st-svg-check-circle st-css-no\" aria-hidden=\"\"><\/i>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u7d50\u5408\u30c7\u30fc\u30bf\u3092\u52a0\u5de5<\/p><div class=\"st-in-mybox\">\n<p>\uff11\uff0e\u5217\u3092\u8ffd\u52a0\u3057\u3066\u3001\u300c\u58f2\u4fa1\u300d\u00d7\u300c\u8ca9\u58f2\u6570\u91cf\u300d\u306e\u5408\u8a08\u5217\u3092\u633f\u5165<\/p>\n\n\n\n<p>\uff12\uff0e\u5217\u306e\u4e26\u3079\u66ff\u3048<\/p>\n\n\n\n<p>\uff13\uff0e\u30d5\u30a3\u30eb\u30bf\u30fc\u3067\u7279\u5b9a\u306e\u5024\u306e\u307f\u8868\u793a<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff11\uff0e\u300c\u7d50\u5408\u300d\u30af\u30a8\u30ea\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30b9\u30c6\u30c3\u30d7\uff12\u3067\u4f5c\u6210\u3057\u305f\u300c\u7d50\u5408\u300d\u30af\u30a8\u30ea\u3092\u7de8\u96c6\u3059\u308b\u305f\u3081\u3001\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-double-click.png\"><img decoding=\"async\" width=\"1240\" height=\"937\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-double-click.png\" alt=\"\u7d50\u5408\u3057\u305f\u30af\u30a8\u30ea\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\" class=\"wp-image-93388\" style=\"width:354px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-double-click.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-double-click-400x302.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-double-click-768x580.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7d50\u5408\u3057\u305f\u30af\u30a8\u30ea\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff12\uff0e\u300c\u30ab\u30b9\u30bf\u30e0\u5217\u300d\u3092\u30af\u30ea\u30c3\u30af<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u304c\u958b\u304d\u307e\u3059\u3002\u300c\u58f2\u4fa1\u300d\u00d7\u300c\u8ca9\u58f2\u6570\u91cf\u300d\u3092\u8a08\u7b97\u3059\u308b\u305f\u3081\u306e\u5217\u3092\u8ffd\u52a0\u3059\u308b\u305f\u3081\u3001\u300c\u5217\u306e\u8ffd\u52a0\u300d\u30bf\u30d6\u306e<strong>\u300c\u30ab\u30b9\u30bf\u30e0\u5217\u300d\u3092\u30af\u30ea\u30c3\u30af<\/strong>\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-addition-1.png\"><img decoding=\"async\" width=\"1240\" height=\"640\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-addition-1.png\" alt=\"\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u8ffd\u52a0\" class=\"wp-image-93394\" style=\"width:636px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-addition-1.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-addition-1-400x206.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-addition-1-768x396.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u8ffd\u52a0<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff13\uff0e\u300c\u30ab\u30b9\u30bf\u30e0\u5217\u300d\u306e\u540d\u524d\u3092\u8a2d\u5b9a<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u30ab\u30b9\u30bf\u30e0\u5217\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u65b0\u3057\u3044\u5217\u540d\u3092\u5165\u529b\u3057\u307e\u3059(\u56f33)\u3002\u6b21\u306b\u30ab\u30b9\u30bf\u30e0\u5217\u306e\u6570\u5f0f\u3092\u5165\u529b\u3059\u308b\u305f\u3081\u3001\u53f3\u5074\u306e\u30ea\u30b9\u30c8\u304b\u3089\u300c\u58f2\u4fa1\u300d\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059(\u56f34)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-name-1.png\"><img decoding=\"async\" width=\"1240\" height=\"779\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-name-1.png\" alt=\"\u30ab\u30b9\u30bf\u30e0\u5217\u306e\u540d\u524d\u3092\u8a2d\u5b9a\" class=\"wp-image-93416\" style=\"width:556px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-name-1.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-name-1-400x251.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-custom-column-name-1-768x482.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30ab\u30b9\u30bf\u30e0\u5217\u306e\u540d\u524d\u3092\u8a2d\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff14\uff0e\u300c\u30ab\u30b9\u30bf\u30e0\u5217\u300d\u306e\u6570\u5f0f\u3092\u8a2d\u5b9a<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u30ab\u30b9\u30bf\u30e0\u5217\u300d\u306e\u5f0f\u3092\u9078\u629e\u3057\u3001\u639b\u7b97\u306e\u305f\u3081\u306e<strong><span class=\"st-mymarker-s\">\u300c*\u300d\u3092\u5165\u529b<\/span><\/strong>\u3057\u307e\u3059(\u56f35)\u3002\u53f3\u5074\u306e\u30ea\u30b9\u30c8\u304b\u3089\u300c\u8ca9\u58f2\u6570\u91cf\u300d\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059(\u56f36)\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><strong><span class=\"oomozi\">=[\u58f2\u4fa1]<span class=\"st-mymarker-s\">*<\/span>[\u8ca9\u58f2\u6570\u91cf]<\/span><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-formula-make-1.png\"><img decoding=\"async\" width=\"1240\" height=\"784\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-formula-make-1.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u30ab\u30b9\u30bf\u30e0\u5f0f\u3092\u4f5c\u6210\" class=\"wp-image-93417\" style=\"width:500px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-formula-make-1.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-formula-make-1-400x253.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-formula-make-1-768x486.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u30ab\u30b9\u30bf\u30e0\u5f0f\u3092\u4f5c\u6210<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u30ab\u30b9\u30bf\u30e0\u5f0f\u306e\u4f5c\u6210\u304c\u7d42\u308f\u3063\u305f\u3089\u300cOK\u300d\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044(\u56f37)\u3002<\/p>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff15\uff0e\u300c\u5408\u8a08\u5217\u300d\u3092\u4e26\u3079\u66ff\u3048<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u306b\u623b\u308b\u3068\u3001\u8a2d\u5b9a\u3057\u305f\u5408\u8a08\u5217\u304c\u4e00\u756a\u53f3\u7aef\u306b\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<span class=\"st-mymarker-s\">\u898b\u51fa\u3057\u3092\u30c9\u30e9\u30c3\u30b0<\/span>\u3059\u308b\u3068<span class=\"st-mymarker-s\">\u5217\u306e\u4e26\u3079\u66ff\u3048<\/span>\u304c\u3067\u304d\u308b\u306e\u3067\u3001\u300c\u8ca9\u58f2\u9ad8\u300d\u5217\u3092\u300c\u8ca9\u58f2\u6570\u91cf\u300d\u5217\u306e\u53f3\u5074\u306b\u79fb\u52d5\u3057\u307e\u3059(\u56f38)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-column-sort.png\"><img decoding=\"async\" width=\"1240\" height=\"551\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-column-sort.png\" alt=\"\u5408\u8a08\u5217\u3092\u8ffd\u52a0\u3057\u4e26\u3079\u66ff\u3048\" class=\"wp-image-93414\" style=\"width:588px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-column-sort.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-column-sort-400x178.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-column-sort-768x341.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u5408\u8a08\u5217\u3092\u8ffd\u52a0\u3057\u4e26\u3079\u66ff\u3048<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u5408\u8a08\u5217\u306b\u9650\u3089\u305a\u3001\u5225\u306e\u5217\u3082\u4e26\u3079\u66ff\u3048\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u8a2d\u5b9a\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff16\uff0e\u30d5\u30a3\u30eb\u30bf\u30fc\u3067\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u7d5e\u308b<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u5546\u54c1\u30b3\u30fc\u30c9\u300d\u306e\u898b\u51fa\u3057\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066(\u56f39)\u3001\u300cA001\u300d\u3060\u3051\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u305f\u72b6\u614b\u306b\u3057\u3066\u304b\u3089(\u56f310)\u3001\u300cOK\u300d\u3092\u62bc\u3057\u307e\u3059(\u56f311)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-filter-function.png\"><img decoding=\"async\" width=\"1240\" height=\"1161\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-filter-function.png\" alt=\"PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u4f7f\u7528\" class=\"wp-image-93428\" style=\"width:366px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-filter-function.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-filter-function-400x375.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-filter-function-768x719.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u4f7f\u7528<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff17\uff0ePowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u7d42\u4e86\u3059\u308b<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u5546\u54c1\u30b3\u30fc\u30c9\u300d\u304cA001\u306e\u307f\u62bd\u51fa\u3055\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u300c\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u9589\u3058\u3066\u304f\u3060\u3055\u3044(\u56f312)\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-finish.png\"><img decoding=\"async\" width=\"1240\" height=\"635\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-finish.png\" alt=\"PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u9589\u3058\u308b\" class=\"wp-image-93439\" style=\"width:618px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-finish.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-finish-400x205.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-editor-finish-768x393.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>PowerQuery\u30a8\u30c7\u30a3\u30bf\u30fc\u3092\u9589\u3058\u308b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff18\uff0e\u7de8\u96c6\u5f8c\u306e\u7d50\u5408\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4ee5\u4e0a\u306e\u4f5c\u696d\u306b\u3088\u308a\u3001\u4e0b\u306e\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8\u306e\u3088\u3046\u306b\u3001\u300c\u5408\u8a08\u5217\u306e\u8ffd\u52a0\u300d\u300c\u4e26\u3079\u66ff\u3048\u300d\u300c\u30d5\u30a3\u30eb\u30bf\u30fc\u300d\u306e\uff13\u3064\u304c\u884c\u308f\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d\u3067\u304d\u308c\u3070\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-edit-before-after.png\"><img decoding=\"async\" width=\"1240\" height=\"306\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-edit-before-after.png\" alt=\"\u7d50\u5408\u30c7\u30fc\u30bf\u306e\u7de8\u96c6\u304c\u5b8c\u4e86\" class=\"wp-image-93444\" style=\"width:670px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-edit-before-after.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-edit-before-after-400x99.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-join-edit-before-after-768x190.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7d50\u5408\u30c7\u30fc\u30bf\u306e\u7de8\u96c6\u304c\u5b8c\u4e86<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u4ee5\u4e0a\u3067\u30b9\u30c6\u30c3\u30d7\uff13\u306e\u4f5c\u696d\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">PowerQuery\/\u30b9\u30c6\u30c3\u30d7\uff14\uff0e\u66f4\u65b0\u30dc\u30bf\u30f3\u3067\u81ea\u52d5\u5316\u3092\u78ba\u8a8d<\/h3>\n\n\n\n<p>\u30b9\u30c6\u30c3\u30d7\uff14\u3067\u306f\u3001\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306b\u3088\u3063\u3066\u300c<span class=\"st-mymarker-s\">\u8907\u6570\u306e<\/span><strong><span class=\"st-mymarker-s\">\u30c7\u30fc\u30bf\u304c\u81ea\u52d5\u3067\u7d50\u5408\u3055\u308c\u3066\u52a0\u5de5<\/span><\/strong>\u300d\u3055\u308c\u308b\u304b\u3069\u3046\u304b\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff11\uff0e\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u30c7\u30fc\u30bf\u3092\u7de8\u96c6<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u7d50\u5408\u3057\u305f\u5143\u30c7\u30fc\u30bf\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3044\u3066\u3001\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u307e\u3059(\u56f31)\u3002\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u305f\u3089\u4e0a\u66f8\u304d\u4fdd\u5b58\u3057\u3066\u3001\u30d5\u30a1\u30a4\u30eb\u306f\u9589\u3058\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-addition.png\"><img decoding=\"async\" width=\"1240\" height=\"1147\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-addition.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306b\u4f7f\u7528\u3057\u305f\u5143\u30c7\u30fc\u30bf\u306b\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\" class=\"wp-image-93452\" style=\"width:400px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-addition.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-addition-400x370.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-basic-data-addition-768x710.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306b\u4f7f\u7528\u3057\u305f\u5143\u30c7\u30fc\u30bf\u306b\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><span style=\"text-decoration: underline;\"><strong>\u624b\u9806\uff12\uff0e\u300c\u7d50\u5408\u300d\u30c7\u30fc\u30bf\u3092\u66f4\u65b0<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u7528\u3057\u305fExcel\u30d6\u30c3\u30af\u3092\u958b\u304d\u307e\u3059\u3002\u300c\u30c7\u30fc\u30bf\u300d\u30bf\u30d6\u306e<span class=\"st-mymarker-s\">\u300c\u3059\u3079\u3066\u66f4\u65b0\u300d\u30dc\u30bf\u30f3<\/span>\u3092\u62bc\u3059\u3068\u3001\u30af\u30a8\u30ea\u306e\u3059\u3079\u3066\u304c<strong><span class=\"st-mymarker-s\">\u6700\u65b0\u306e\u72b6\u614b\u306b\u66f4\u65b0<\/span><\/strong>\u3055\u308c\u3001\u300c\u8ca9\u58f2\u660e\u7d30\u300d\u306b\u8ffd\u52a0\u3057\u305f\uff11\u884c\u3082\u52a0\u5de5\u3055\u308c\u3066\u53cd\u6620\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update.png\"><img decoding=\"async\" width=\"1240\" height=\"700\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u3059\u3079\u3066\u306e\u66f4\u65b0\" class=\"wp-image-93458\" style=\"width:592px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update-400x226.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update-768x434.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u3059\u3079\u3066\u306e\u66f4\u65b0<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u30c7\u30fc\u30bf\u306e\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u306f\u3001\u300c\u30af\u30a8\u30ea\u300d\u30bf\u30d6\u306e\u300c\u66f4\u65b0\u300d\u30dc\u30bf\u30f3\u304b\u3089\u3067\u3082\u3001\u5143\u30c7\u30fc\u30bf\u306e\u60c5\u5831\u3092\u518d\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305f\u3060\u3057\u3001\u8907\u6570\u306e\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u4e00\u90e8\u306e\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3057\u5fd8\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u306e\u3067\u3001\u300c\u3059\u3079\u3066\u66f4\u65b0\u300d\u30dc\u30bf\u30f3\u3092\u4f7f\u3046\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update-how-to.png\"><img decoding=\"async\" width=\"1240\" height=\"390\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update-how-to.png\" alt=\"\u300c\u30af\u30a8\u30ea\u300d\u30bf\u30d6\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3059\u308b\" class=\"wp-image-93465\" style=\"width:584px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update-how-to.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update-how-to-400x126.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-update-how-to-768x242.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300c\u30af\u30a8\u30ea\u300d\u30bf\u30d6\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3059\u308b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u305d\u306e\uff12(\u8907\u6570\u30c7\u30fc\u30bf\u306e\u4e00\u62ec\u53d6\u308a\u8fbc\u307f) <\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3048\u3070\u3001\u4e0b\u306e\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8\u306e\u3088\u3046\u306b\u3001\u7279\u5b9a\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u4fdd\u7ba1\u3055\u308c\u3066\u3044\u308b<span class=\"st-mymarker-s\">\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u3092\u4e00\u62ec\u3067\u53d6\u308a\u8fbc\u3080<\/span>\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file.png\"><img decoding=\"async\" width=\"1240\" height=\"690\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file.png\" alt=\"\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u304c\uff11\u3064\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u4fdd\u7ba1\" class=\"wp-image-93503\" style=\"width:548px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file-400x223.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file-768x427.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u304c\uff11\u3064\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u4fdd\u7ba1<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3046\u3068\u3001\u4e0b\u306e\u3088\u3046\u306b\u3001\uff11\u3064\u306e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b12\u500b\u306e\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u3092\u307e\u3068\u3081\u3066\u4e00\u62ec\u3067\u30c7\u30fc\u30bf\u51fa\u529b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file-import.png\"><img decoding=\"async\" width=\"1240\" height=\"651\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file-import.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u3092\u307e\u3068\u3081\u3066\u4e00\u62ec\u3067\u30c7\u30fc\u30bf\u51fa\u529b\" class=\"wp-image-93506\" style=\"width:590px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file-import.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file-import-400x210.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-multiple-file-import-768x403.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067\u8907\u6570\u30d5\u30a1\u30a4\u30eb\u3092\u307e\u3068\u3081\u3066\u4e00\u62ec\u3067\u30c7\u30fc\u30bf\u51fa\u529b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u4f7f\u3044\u65b9\u306f\u3001\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3067\u8a73\u3057\u304f\u7d39\u4ecb\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u8208\u5473\u306e\u3042\u308b\u65b9\u306f\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-excel wp-block-embed-excel\"><div class=\"wp-block-embed__wrapper\">\n<div><a href=\"https:\/\/www.excel-no-mori-blog.jp\/?p=62423\" class=\"st-cardlink st-embed-cardlink\"><div class=\"kanren st-cardbox\"><dl class=\"clearfix\"><dt class=\"st-card-img\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/04\/excel-import-datafolder-multiple-files-power-query-1-1000x530.png\" alt=\"\" width=\"100\" height=\"100\" \/><\/dt><dd><p class=\"st-cardbox-t\">\u3010\u30a8\u30af\u30bb\u30eb\u3011\u8907\u6570\u306eExcel\u30d6\u30c3\u30af\u3092\u4e00\u3064\u306b\u7d50\u5408\u3059\u308b\u65b9\u6cd5\u3002\u5927\u91cf\u30c7\u30fc\u30bf\u3092\u4e00\u62ec\u3067\u53d6\u5f97\u3059\u308b\u624b\u9806\u3092\u7d39\u4ecb<\/p><div class=\"st-card-excerpt smanone\"><p>\u8907\u6570\u306eExcel\u30d6\u30c3\u30af\u3092\uff11\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u307e\u3068\u3081\u308b\u6642\u3001\u3059\u3079\u3066\u306eExcel\u30d6\u30c3\u30af\u3092\u958b\u3044\u3066\u30b3\u30d4\u30da\u3092\u7e70\u308a\u8fd4\u3059\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u3001\u5927\u91cf &#8230; <\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n\n\n\n<div style=\"height:52px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u305d\u306e\uff13(CSV\u30d5\u30a1\u30a4\u30eb\u306e\u53d6\u308a\u8fbc\u307f) <\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3048\u3070\u3001<span class=\"st-mymarker-s\">CSV\u30d5\u30a1\u30a4\u30eb<\/span>\u3084<span class=\"st-mymarker-s\">\u30c6\u30ad\u30b9\u30c8<\/span>\u3082Excel\u30d6\u30c3\u30af\u306b\u53d6\u308a\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6570\u5024\u306e\u5148\u982d\u300c0\u300d\u304c\u6d88\u3048\u306a\u3044\u3088\u3046\u306b\u8868\u793a\u3055\u305b\u308b\u306a\u3069\u3001\u8868\u793a\u5f62\u5f0f\u3092\u5909\u66f4\u3059\u308b\u306e\u306b\u3082\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306f\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u30c7\u30fc\u30bf\u300d\u30bf\u30d6\u306e\u300c\u30c6\u30ad\u30b9\u30c8\u307e\u305f\u306fCSV\u304b\u3089\u300d\u30dc\u30bf\u30f3\u304b\u3089\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3092\u958b\u59cb\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-csv-text-file-import.png\"><img decoding=\"async\" width=\"1240\" height=\"585\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-csv-text-file-import.png\" alt=\"\u300c\u30c6\u30ad\u30b9\u30c8\u307e\u305f\u306fCSV\u304b\u3089\u300d\u30dc\u30bf\u30f3\" class=\"wp-image-93512\" style=\"width:476px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-csv-text-file-import.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-csv-text-file-import-400x189.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-csv-text-file-import-768x362.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300c\u30c6\u30ad\u30b9\u30c8\u307e\u305f\u306fCSV\u304b\u3089\u300d\u30dc\u30bf\u30f3<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:52px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u4f7f\u3044\u65b9\u306f\u3001\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3067\u8a73\u3057\u304f\u7d39\u4ecb\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u8208\u5473\u306e\u3042\u308b\u65b9\u306f\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-excel wp-block-embed-excel\"><div class=\"wp-block-embed__wrapper\">\n<div><a href=\"https:\/\/www.excel-no-mori-blog.jp\/?p=19882\" class=\"st-cardlink st-embed-cardlink\"><div class=\"kanren st-cardbox\"><dl class=\"clearfix\"><dt class=\"st-card-img\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2022\/09\/excel-csv-head-0-display-1-1000x530.png\" alt=\"\" width=\"100\" height=\"100\" \/><\/dt><dd><p class=\"st-cardbox-t\">\u3010CSV\u30d5\u30a1\u30a4\u30eb\u3011\u5148\u982d\u306e\u300c0\uff08\u30bc\u30ed\uff09\u300d\u3092\u8868\u793a\u3057\u3066\u30a8\u30af\u30bb\u30eb\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5<\/p><div class=\"st-card-excerpt smanone\"><p>CSV\u30d5\u30a1\u30a4\u30eb\u3092\u5916\u90e8\u30b7\u30b9\u30c6\u30e0\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3001Excel(\u30a8\u30af\u30bb\u30eb)\u3067\u958b\u304f\u3068\u5148\u982d\u306e\u300c0(\u30bc\u30ed)\u300d\u304c\u52dd\u624b\u306b\u6d88\u3048\u3066\u3057\u307e\u3044\u307e &#8230;<\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n\n\n\n<div style=\"height:52px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u305d\u306e\uff14(PDF\u30d5\u30a1\u30a4\u30eb\u306e\u53d6\u308a\u8fbc\u307f)<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3048\u3070\u3001PDF\u30d5\u30a1\u30a4\u30eb\u3082Excel\u30d6\u30c3\u30af\u306b\u53d6\u308a\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-pdf-file-import.png\"><img decoding=\"async\" width=\"1240\" height=\"415\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-pdf-file-import.png\" alt=\"\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u3066PDF\u3092Excel\u306b\u53d6\u308a\u8fbc\u3080\" class=\"wp-image-93524\" style=\"width:622px;height:auto\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-pdf-file-import.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-pdf-file-import-400x134.png 400w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2025\/03\/excel-power-query-pdf-file-import-768x257.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u3066PDF\u3092Excel\u306b\u53d6\u308a\u8fbc\u3080<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:52px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u3053\u306e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u4f7f\u3044\u65b9\u306f\u3001\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3067\u8a73\u3057\u304f\u7d39\u4ecb\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u8208\u5473\u306e\u3042\u308b\u65b9\u306f\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-excel wp-block-embed-excel\"><div class=\"wp-block-embed__wrapper\">\n<div><a href=\"https:\/\/www.excel-no-mori-blog.jp\/?p=7277\" class=\"st-cardlink st-embed-cardlink\"><div class=\"kanren st-cardbox\"><dl class=\"clearfix\"><dt class=\"st-card-img\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2022\/05\/pdf-excel-conversion-word-method-1-1-1000x530.png\" alt=\"\" width=\"100\" height=\"100\" \/><\/dt><dd><p class=\"st-cardbox-t\">PDF\u306e\u8868\u3092Excel\u306b\u5909\u63db\u3059\u308b\uff13\u3064\u306e\u65b9\u6cd5\uff01Word\u3084\u30e1\u30e2\u5e33\u3092\u4f7f\u3063\u305f\u5909\u63db\u624b\u9806\u3092\u89e3\u8aac\u3002<\/p><div class=\"st-card-excerpt smanone\"><p>PDF\u306b\u542b\u307e\u308c\u308b\u8868\u3092Excel (\u30a8\u30af\u30bb\u30eb)\u306b\u5229\u7528\u3057\u305f\u3044\u6642\u3042\u308a\u307e\u3059\u3088\u306d\u3002 \u5358\u7d14\u306bPDF\u306e\u8868\u3092\u30b3\u30d4\u30fc\u3057\u3066Excel\u306b\u8cbc\u308a\u4ed8 &#8230;<\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n\n\n\n<div style=\"height:52px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306f\u521d\u5fc3\u8005\u306b\u3082\u4f7f\u3048\u308b\u300c\u81ea\u52d5\u5316\u300d\u30c4\u30fc\u30eb\uff01<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eca\u56de\u306f\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306e\u4ed5\u7d44\u307f\u3068\u3001\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u305f\u4e8b\u4f8b\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306f\u3001\u30a8\u30af\u30bb\u30eb\u306e<span class=\"st-mymarker-s\">\u300c\u81ea\u52d5\u5316\u300d\u306b\u6700\u9069\u306a\u30c4\u30fc\u30eb<\/span>\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6bce\u6708\u3001\u5916\u90e8\u30b7\u30b9\u30c6\u30e0\u304b\u3089\u540c\u3058\u5f62\u306e\u30c7\u30fc\u30bf\u3092\u51fa\u529b\u3057\u52a0\u5de5\u3057\u3066\u3044\u308b\u3088\u3046\u306a\u4f5c\u696d\u3067\u3042\u308c\u3070\u3001\u7279\u306b\u30a8\u30af\u30bb\u30eb\u306e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3068\u76f8\u6027\u304c\u3044\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u3067IF\u95a2\u6570(IF\u6587)\u3092\u5229\u7528\u3059\u308b\u5834\u5408\u306a\u3069\u3001\u899a\u3048\u308b\u30c6\u30af\u30cb\u30c3\u30af\u306f\u6570\u591a\u304f\u3042\u308a\u307e\u3059\u304c\u3001\u307e\u305a\u306f\u601d\u3044\u3064\u304f\u7c21\u5358\u306a\u4f5c\u696d\u3092\u81ea\u52d5\u5316\u3057\u3066\u6642\u77ed\u306b\u3064\u306a\u3052\u3066\u3044\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30d1\u30ef\u30fc\u30af\u30a8\u30ea\u306b\u4f7f\u3044\u6163\u308c\u3066\u304d\u305f\u3089\u3001\u4ee5\u4e0b\u306e\u8a18\u4e8b\u304b\u3089\u30de\u30af\u30ed(VBA)\u306e\u5229\u7528\u306b\u3082\u30c1\u30e3\u30ec\u30f3\u30b8\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-excel wp-block-embed-excel\"><div class=\"wp-block-embed__wrapper\">\n<div><a href=\"https:\/\/www.excel-no-mori-blog.jp\/?p=58393\" class=\"st-cardlink st-embed-cardlink\"><div class=\"kanren st-cardbox\"><dl class=\"clearfix\"><dt class=\"st-card-img\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/03\/excel-macro-beginner-basics-illustration-how-to-use-automation-1-1000x530.png\" alt=\"\" width=\"100\" height=\"100\" \/><\/dt><dd><p class=\"st-cardbox-t\">\u3010\u521d\u5fc3\u8005\u5411\u3051\u3011\u30a8\u30af\u30bb\u30eb\u306e\u30de\u30af\u30ed\u306e\u4f7f\u3044\u65b9\u3068\u624b\u9806\u3092\u7d39\u4ecb\u3002\u81ea\u52d5\u5316\u306e\u5b9f\u4f8b\u3068\u57fa\u672c\u64cd\u4f5c\u3092\u89e3\u8aac<\/p><div class=\"st-card-excerpt smanone\"><p>Microsoft\u306eExcel\u306e\u30de\u30af\u30ed\u3068\u306f\u3001\u30a8\u30af\u30bb\u30eb\u306e\u4e00\u9023\u306e\u64cd\u4f5c\u3092\u81ea\u52d5\u5316\u3059\u308b\u305f\u3081\u306e\u6a5f\u80fd\u306e\u3053\u3068\u3067\u3059\u3002 \u30de\u30af\u30ed\u3068\u805e\u304f\u3068\u3001\u30d7\u30ed &#8230;<\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30a8\u30af\u30bb\u30eb\u306e\u30d1\u30ef\u30fc\u30af\u30a8\u30ea(PowerQuery)\u306f\u3001\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u81ea\u52d5\u5316\u3059\u308b\u306e\u306b\u975e\u5e38\u306b\u5f79\u7acb\u3064\u6a5f\u80fd\u3067\u3059\u3002 Excel2016\u306e &#8230;<\/p>\n","protected":false},"author":1,"featured_media":93484,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,36],"tags":[],"class_list":["post-93040","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-36"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/93040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=93040"}],"version-history":[{"count":1,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/93040\/revisions"}],"predecessor-version":[{"id":96528,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/93040\/revisions\/96528"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/media\/93484"}],"wp:attachment":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=93040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=93040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=93040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}