{"image_url":null,"width":"100%","author_url":"https://blog.hatena.ne.jp/xlogI125/","height":"190","blog_url":"https://dy100ms.hatenadiary.jp/","title":"Power Query: \u91cd\u8907\u524a\u9664\u306e\u969b\u306b\u6700\u65b0\u65e5\u4ed8\u3092\u6b8b\u3059","author_name":"xlogI125","categories":["Power Query","Excel"],"type":"rich","description":"Table.Distinct, Table.NestedJoin, Table.TransformRows, Table.Sort, Table.First, Table.FromRecords\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u8003\u3048\u308b\u3002Table.Group\u3068\u306e\u9055\u3044\u306f\u672a\u78ba\u8a8d\u3002 \u30af\u30a8\u30ea1, 2, 3 \u30af\u30a8\u30ea1: \u5143\u306e\u30c6\u30fc\u30d6\u30eb // \u30af\u30a8\u30ea1 \u8a73\u7d30\u30a8\u30c7\u30a3\u30bf\u30fc Table.FromRows( { {\"A\", \"2020/1/1\", 1, \"a\"}, {\"A\", \"2020/2/2\", 2, \"b\"}, {\"A\", \"2020/3/3\", 3, \"c\"}, {\"A\", \"2020/4/4\", 4, \"d\"}, {\"A\",\u2026","published":"2026-01-21 00:00:00","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdy100ms.hatenadiary.jp%2Fentry%2F2026%2F01%2F21%2F000000\" title=\"Power Query: \u91cd\u8907\u524a\u9664\u306e\u969b\u306b\u6700\u65b0\u65e5\u4ed8\u3092\u6b8b\u3059 - xlogI125\u2019s blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","provider_name":"Hatena Blog","url":"https://dy100ms.hatenadiary.jp/entry/2026/01/21/000000","provider_url":"https://hatena.blog","blog_title":"xlogI125\u2019s blog"}