{"id":872,"date":"2021-01-01T22:09:31","date_gmt":"2021-01-01T13:09:31","guid":{"rendered":"https:\/\/beiyan-tool.info\/?p=872"},"modified":"2021-01-01T22:09:31","modified_gmt":"2021-01-01T13:09:31","slug":"excel-%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ae%e5%8f%96%e3%82%8a%e8%be%bc%e3%81%bf%e3%81%a7%e5%88%97%e3%82%bf%e3%82%a4%e3%83%88%e3%83%ab%e3%81%8c%e5%8f%96%e5%be%97%e3%81%a7%e3%81%8d%e3%81%aa%e3%81%84","status":"publish","type":"post","link":"https:\/\/beiyan-tool.info\/?p=872","title":{"rendered":"Excel \u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f\u3067\u5217\u30bf\u30a4\u30c8\u30eb\u304c\u53d6\u5f97\u3067\u304d\u306a\u3044\u5834\u5408\u306e\u5bfe\u51e6\u6cd5"},"content":{"rendered":"<p>\u30a8\u30af\u30bb\u30eb\u3067Power Query\u3092\u4f7f\u304a\u3046\u3068\u8003\u3048\u3066\u3001<br \/>\n\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f\u3092\u884c\u3063\u305f\u3068\u304d\u3001<br \/>\n\u5217\u306e\u30bf\u30a4\u30c8\u30eb\u304c\u3001Column1\u3001Column2\u3001Column3\u3068\u306a\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3001\u6b21\u306e\u3088\u3046\u306a\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3082\u3046\u3068\u3057\u305f\u3068\u304d\u306b\u8d77\u304d\u308b\u73fe\u8c61\u3067\u3059\u3002<\/p>\n<p><a href=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle1.jpg\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-873\" src=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle1-300x100.jpg\" alt=\"\" width=\"300\" height=\"100\" srcset=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle1-300x100.jpg 300w, https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle1.jpg 415w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u3053\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle2.jpg\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-874\" src=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle2-300x241.jpg\" alt=\"\" width=\"300\" height=\"241\" srcset=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle2-300x241.jpg 300w, https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle2-768x618.jpg 768w, https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle2.jpg 848w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u3053\u308c\u3092\u89e3\u6c7a\u3057\u307e\u3059\u3002<\/p>\n\n\t<p style=\"color:#666;margin-bottom:5px;\">\u30b9\u30dd\u30f3\u30b5\u30fc\u30ea\u30f3\u30af<\/p>\n\t<div class=\"middle-ad\">\n\t\t\t\t\t\t\t<div class=\"textwidget\"><p><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- \u6b66\u8853\u304c\u597d\u304d --><br \/>\n<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-client=\"ca-pub-8986630938426235\"\n     data-ad-slot=\"2584434263\"\n     data-ad-format=\"auto\"\n     data-full-width-responsive=\"true\"><\/ins><br \/>\n<script>\n(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<\/div>\n\t\t\t\t\t\t<\/div>\n\n\n<p>\u307e\u305a\u300c\u30c7\u30fc\u30bf\u306e\u5909\u63db\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle3.jpg\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-875\" src=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle3-300x143.jpg\" alt=\"\" width=\"300\" height=\"143\" srcset=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle3-300x143.jpg 300w, https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle3.jpg 732w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u6b21\u306b\u300c\uff11\u884c\u76ee\u3092\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u4f7f\u7528\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle4.jpg\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-876\" src=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle4-300x144.jpg\" alt=\"\" width=\"300\" height=\"144\" srcset=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle4-300x144.jpg 300w, https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle4.jpg 645w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u300c\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080\u300d\u3092\u30af\u30ea\u30c3\u30af<\/p>\n<p><a href=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle5.jpg\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-877\" src=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle5-300x189.jpg\" alt=\"\" width=\"300\" height=\"189\" srcset=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle5-300x189.jpg 300w, https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle5.jpg 396w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u3053\u308c\u3067\u3061\u3083\u3093\u3068\u8aad\u307f\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n<p><a href=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle6.jpg\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-878\" src=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle6-300x161.jpg\" alt=\"\" width=\"300\" height=\"161\" srcset=\"https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle6-300x161.jpg 300w, https:\/\/beiyan-tool.info\/wp-content\/uploads\/2021\/01\/epq-columntitle6.jpg 561w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u3053\u308c\u554f\u984c\u306e\u539f\u56e0\u306f\u304a\u305d\u3089\u304f\u3001\u5168\u3066\u306e\u30bb\u30eb\u304c\u6587\u5b57\u5217\u3060\u304b\u3089\u3067\u3059\u3002<br \/>\n\u8a66\u3057\u306b\u30c6\u30fc\u30d6\u30eb\u306e\u5185\u5bb9\u3092\u66f8\u304d\u63db\u3048\u3066\u307f\u305f\u3068\u3053\u308d\u3001\u3061\u3083\u3093\u3068\u5217\u540d\u304c\u53d6\u5f97\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<p>\u4eca\u56de\u3001\u3053\u306e\u554f\u984c\u306b\u6c17\u3065\u3044\u305f\u306e\u306f\u3001Kinde Unlimited\u3067\u300c<a href=\"https:\/\/www.amazon.co.jp\/gp\/product\/B07SFHHHPQ\/ref=as_li_tl?ie=UTF8&amp;camp=247&amp;creative=1211&amp;creativeASIN=B07SFHHHPQ&amp;linkCode=as2&amp;tag=bujyutsu-suki-22&amp;linkId=1dcc3f30fb6bff9ac6c95598789af36b\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Power Query\u5165\u9580<\/a><img decoding=\"async\" style=\"border: none !important; margin: 0px !important;\" src=\"\/\/ir-jp.amazon-adsystem.com\/e\/ir?t=bujyutsu-suki-22&amp;l=am2&amp;o=9&amp;a=B07SFHHHPQ\" alt=\"\" width=\"1\" height=\"1\" border=\"0\" \/>\u300d\u3092\u8aad\u3093\u3067\u3044\u305f\u3068\u304d\u3067\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30a8\u30af\u30bb\u30eb\u3067Power Query\u3092\u4f7f\u304a\u3046\u3068\u8003\u3048\u3066\u3001 \u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f\u3092\u884c\u3063\u305f\u3068\u304d\u3001 \u5217\u306e\u30bf\u30a4\u30c8\u30eb\u304c\u3001Column1\u3001Column2\u3001Column3\u3068\u306a\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002 \u4f8b\u3048\u3070\u3001\u6b21 &#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-872","post","type-post","status-publish","format-standard","hentry","category-windows"],"_links":{"self":[{"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/posts\/872","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=872"}],"version-history":[{"count":1,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/posts\/872\/revisions"}],"predecessor-version":[{"id":879,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=\/wp\/v2\/posts\/872\/revisions\/879"}],"wp:attachment":[{"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beiyan-tool.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}