Combine data with inconsistent headers in Power Query

Contents

• Introduction Introduction

  • Advanced Power Query techniques

    38s
  • (Locked)
    What you should know

    43s
• 1. What Is M and Why Care About It? 1. What Is M and Why Care About It?

  • (Locked)
    Examine Power Query UI limitations: Examples

    5m 32s
  • (Locked)
    Where is M in Power Query?

    5m 13s
  • Introduction to M in Power Query: Core concepts

    7m 56s
  • (Locked)
    Value types in M: Structured vs. primitive

    2m
• 2. Working with Lists in Power Query 2. Working with Lists in Power Query

  • (Locked)
    What is a list in Power Query?

    8m 6s
  • (Locked)
    Dynamically expand nested tables: Example 1

    12m
  • (Locked)
    Dynamic unpivoting for cross tabulated data: Example 2

    10m 30s
  • (Locked)
    Challenge: Remove junk column names

    1m 45s
  • (Locked)
    Solution: Remove junk column names

    11m 5s
• 3. Power Query Functions: Input/Output Essentials 3. Power Query Functions: Input/Output Essentials

  • (Locked)
    Feed what Power Query eats

    7m 53s
• 4. Working with Records in Power Query 4. Working with Records in Power Query

  • (Locked)
    What is a record in Power Query?

    6m 30s
  • (Locked)
    Add multiple columns to a table using records: Example 1

    8m
  • Add a total column using records: Example 2

    5m 29s
  • (Locked)
    Challenge: Count unique visits

    54s
  • (Locked)
    Solution: Count unique visits

    2m 59s
• 5. Working with Iterations in Power Query 5. Working with Iterations in Power Query

  • What are iterations in Power Query?

    7m 36s
  • (Locked)
    The syntax for iterations: Understanding each _ (underscore)

    4m 38s
  • (Locked)
    The syntax for iterations: Understanding functions

    5m 52s
  • (Locked)
    Using iterations in a new column

    9m 32s
  • (Locked)
    Learning iterations by transforming multiple columns

    11m 28s
  • (Locked)
    Challenge: Add quarter prefix to columns

    1m 23s
  • (Locked)
    Solution: Add quarter prefix to columns

    8m 28s
• 6. Working with Custom Functions in Power Query 6. Working with Custom Functions in Power Query

  • (Locked)
    What is a custom function?

    11m 11s
  • (Locked)
    Replicate Excel's TRIM function

    10m 43s
  • (Locked)
    Calculating the fiscal quarter for dates: Example 1

    14m 8s
  • (Locked)
    Calculating the fiscal year for dates: Example 2

    6m 1s
• 7. Patterns and Recipes in Power Query 7. Patterns and Recipes in Power Query

  • (Locked)
    Combine data with inconsistent headers in Power Query

    17m 52s
  • (Locked)
    Remove top junk rows and combine data

    12m 19s
  • (Locked)
    Handling double headers

    11m 27s
  • (Locked)
    Dynamically split by columns

    7m 39s