【Excel】マウス操作だけのパワークエリからレベルアップ！カスタム関数クエリでワンランク上のデータ整形【YT0173】

This article explains how to format structured Excel workbook data, organized sheet by sheet and table by table within each sheet, into a database-style table using Power Query custom functions. Yuichi Chiba ━━━━━━━━━━━━━━━━━━━━━ ✅️ References ━━━━━━━━━━━━━━━━━━━━━ 🔗#0510. [Part 1] Creating and reusing custom function queries for data transformation    • #0510.【前編】カスタム関数クエリを作り、データ変換に使い回す   🔗#0511. [Part 2] Creating and reusing custom function queries for data transformation    • #0511.【後編】カスタム関数クエリを作り、データ変換に使い回す   ━━━━━━━━━━ ━━━━━━━━━━━ 🎦 Playlist ━━━━━━━━━━━━━━━━━━━━━    • Excelでパワークエリやパワーピボット/DAXを活用する   ━━━━━━━━━━━━━━━━━━━━━ ✅️ Membership ━━━━━━━━━━━━━━━━━━━━━ You can check member-exclusive benefits from the link below.    / @exceldokatach   ━━━━━━━━━━━━━━━━━━━━━ ✅️ Excel Workers' Gathering Place ━━━━━━━━━━━━━━━━━━━━━ 🔥Latest Video🔥 【Basic Power Query Functions (Other)】 '#0510. [Part 1] Creating Custom Function Queries and Reusing Them for Data Transformation' 🎞️【Membership Only [Regular Video] View on:    • #0510.【前編】カスタム関数クエリを作り、データ変換に使い回す   🎞️ [Excel Dokata's Gathering Place] View on: https://excel-dokata.mish.tv/ja/video... 💻 [Excel Dokata's Gathering Place] TOP https://excel-dokata.mish.tv/ ━━━━━━━━━━━━━━━━━━━━━ ✅️ X (Former Twitter) ━━━━━━━━━━━━━━━━━━━━━ We tweet about video updates and more.   / chiba_u1   ━━━━━━━━━━━━━━━━━━━━━ ✅️ Online Courses ━━━━━━━━━━━━━━━━━━━━━ 🔗Excel Power Queries [Beginner Level] https://uyrDOv.short.gy/sutoaka-class... 🔗Excel Power Queries [Elementary Level] https://uyrDOv.short.gy/sutoaka-class... 🔗Excel Power Pivot Tables [Elementary Level] https://uyrDOv.short.gy/sutoaka-class... 🔗Excel Pivot Tables [Beginner Level] https://uyrDOv.short.gy/sutoaka-class... 🔗 Online Course List https://uyrDOv.short.gy/sutoaka-teacher ━━━━━━━━━━━━━━━━━━━━━ ✅️ Article Posting ━━━━━━━━━━━━━━━━━━━━━ I post articles about Excel functions, Power Queries, Power Pivot, and DAX. https://note.com/excel_dokata ━━━━━━━━━━━━━━━━━━━━━ ✅️ Contact Information for Business Inquiries ━━━━━━━━━━━━━━━━━━━━━ For inquiries regarding outsourcing, contract work, instructor requests, consulting, private lessons, etc., please contact me here. [email protected] ━━━━━━━━━━━━━━━━━━━━━ ✅️ Excel Version ━━━━━━━━━━━━━━━━━━━━━ The Excel used in this video is Microsoft 365 Personal (Office Insider Beta, the latest version at the time of video release). ━━━━━━━━━━━━━━━━━━━━━ ✅️ Sample File ━━━━━━━━━━━━━━━━━━━━━ 【Membership (Serious Union Members and above) Only】    • Post   ━━━━━━━━━━━━━━━━━━━━━ ✅️ Timestamps ━━━━━━━━━━━━━━━━━━━━━ [ 00:00 ] Introduction [ 00:32 ] Data Before Formatting [ 02:11 ] Structural Analysis and Confirmation of Formatting Procedure [ 05:57 ] Retrieving Data with a Query [ 09:12 ] Creating a Sample Sheet [ 10:30 ] Preparing the Function Query for Sheet Conversion [14:30] Creating a Sample Gender Table [15:26] Preparing the Function Query for Gender Table Conversion [20:08] Converting the Gender Table Conversion Query into a Function [23:50] Converting the Sheet Conversion Query into a Function [26:13] Merging All Sheets [27:56] Loading into Sheets [28:56] (Bonus) Adding a Sheet [30:01] Conclusion ━━━━━━━━━━━━━━━━━━━━━ ✅️ Online Individual Consultation ━━━━━━━━━━━━━━━━━━━━━ You can consult about Excel using Zoom. https://uyrDOv.short.gy/sutoaka-reque...