This helps protect our community. Learn more

Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query

49.5K subscribers

13K views 7 days ago #MsExcel

Sign up for our free Insiders program and get the example file: Click here: https://exceloffthegrid.com/insiders-... File Reference for this video: 0260 PQ Transform Sample Sheet ★ Want to become an Excel ninja? Check out our training academy ★ https://exceloffthegrid.com/ ★ About this video ★ In this video, learn how to use Power Query to combine multiple Excel sheets effortlessly by creating a Transform Sample Sheet. Understand the step-by-step process of setting up a parameter, creating a function, and applying transformations to multiple worksheets simultaneously. Follow along with the provided example file and get to grips with advanced Power Query techniques for seamless data integration. 00:00 Introduction 00:47 Scenario 01:21 Import data into Power Query 02:43 Create parameter 04:17 Transform Sample Sheet 04:49 Create function 06:20 Sheet transformations 08:51 Create sample sheet 09:29 Invoke function 12:19 Wrap-up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: / exceloffthegrid #MsExcel

...more

Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query

644Likes

13,278Views

Apr 242025

How this content was made

Auto-dubbed

Audio tracks for some languages were automatically generated. Learn more

Introduction

0:00

Scenario

0:47

Import data into Power Query

1:21

Create parameter

2:43

Transcript

Follow along using the transcript.

Excel Off The Grid

49.5K subscribers

Become an Insider to get Example files and more.

Click here

Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query

Chapters View all

Introduction

Introduction

Introduction

Scenario

Scenario

Scenario

Import data into Power Query

Import data into Power Query

Import data into Power Query

Create parameter

Create parameter

Create parameter

Transform Sample Sheet

Transform Sample Sheet

Transform Sample Sheet

Create function

Create function

Create function

Sheet transformations

Sheet transformations

Sheet transformations

Create sample sheet

Create sample sheet

Create sample sheet

Excel Off The Grid

Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query

Comments 37

Chapters

Introduction

Introduction

Introduction

Scenario

Scenario

Scenario

Import data into Power Query

Import data into Power Query

Import data into Power Query

Create parameter

Create parameter

Create parameter

Transform Sample Sheet

Transform Sample Sheet

Transform Sample Sheet

Create function

Create function

Create function

Sheet transformations

Sheet transformations

Sheet transformations

Create sample sheet

Create sample sheet

Create sample sheet

Invoke function

Invoke function

Invoke function

Wrap-up

Wrap-up

Wrap-up

Description

Chapters View all

Introduction

Introduction

Introduction

Scenario

Scenario

Scenario

Import data into Power Query

Import data into Power Query

Import data into Power Query

Create parameter

Create parameter

Create parameter

Excel Off The Grid

Transcript

Custom Sorting with Excel formulas - Taking SORTBY to the next level!

Complete report in Excel with just ONE formula!

10 awesome Power Query tricks you NEED to know! | Excel Off The Grid

How to use Microsoft Power Query

Chapters

Chapters