[Excel] Pivot tables are a useful feature that can be used to pivot and unpivot data. 😲 [YT0194]
This video explains how to convert a matrix table (crosstab) into a database format using Excel pivot tables.
Yuichi Chiba
━━━━━━━━━━━━━━━━━━━━━
✅️ Reference
━━━━━━━━━━━━━━━━━━━━━
🔗#0634. Converting a multi-level matrix table to a database format
• #0634.列項目が多段階のマトリクス形式の表をデータベース形式に変換する
━━━━━━━━━━━━━━━━━━━━━
🎦 Playlist
━━━━━━━━━━━━━━━━━━━━━
https://www.youtube.com/ playlist?list=PLVCXH2zKxEnFYi4sNY8VHtOZMxRFTM-Fr
• Excel Tips
━━━━━━━━━━━━━━━━━━━━━
✅️ Membership
━━━━━━━━━━━━━━━━━━━━━
You can check member-exclusive benefits from the link below.
/ @exceldokatach
━━━━━━━━━━━━━━━━━━━━━
✅️ Excel Workers' Gathering Place
━━━━━━━━━━━━━━━━━━━━━
🔥Latest Video🔥
【Power Query Practical Techniques】
『#0678.【Part 3】The M Function for String Manipulation』
🎞️【Membership Exclusive Video】Viewable Listen
• #0678.【Part3】文字列操作のM関数
🎞️ Watch on [Excel Dokata's Gathering Place]
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 other things.
/ 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
━━━━━━━━━━━━━━━━━━━━━
✅️ Timestamp
━━━━━━━━━━━━━━━━━━━━━
[ 00:00 ] Introduction
[ 00:31 ] Example 1
[ 01:37 ] Creating a Pivot Table
[ 02:11 ] Arranging Fields
[ 04:04 ] Changing the Design
[ 05:02 ] Organizing the Table
[ 05:58 ] [Completed]
[06:26] Example 2
[10:20] The End
━━━━━━━━━━━━━━━━━━━━━
✅️ Online Individual Consultation
━━━━━━━━━━━━━━━━━━━━━
You can consult about Excel using Zoom.
https://uyrDOv.short.gy/sutoaka-reque...