Replace column names of nested tables using Power Query | Excel Off The Grid

preview_player
Показать описание
★ Want to automate Excel? Check out our training academy ★

★ Check out the blog post★

★ About this video ★
Power Query is a nightmare when we want to combine data with different column names, and even worse when those columns are not in the same order. Can we even combine that data? You bet we can!

We're looking at that today; using Power Query to rename columns in nested tables based on a list, without creating errors.

0:00 Introduction
0:22 Scenario
1:58 Promote headers
4:54 Rename columns
8:41 Rename based on a table
10:25 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel
  1. Excel Off The Grid
Рекомендации по теме
Replace column names 0:11:01

Replace column names of nested tables using Power Query | Excel Off The Grid

Forget the Hard-Coded 0:07:00

Forget the Hard-Coded Column Names - Change Data Type To All Columns In a Table

Adding the file 0:06:10

Adding the file name to nested tables

Transform Column Names 0:19:23

Transform Column Names in Bulk in Power Query

How to rename 0:18:21

How to rename column name in Pyspark with 5 different methods #WithColumnRenamed

Power BI - 0:00:27

Power BI - Matrix Visualization - move values from columns to rows

Dynamic Column Names 0:09:24

Dynamic Column Names in Power Query

Power Query - 0:12:37

Power Query - Advanced Transformation of Nested Tables

Oracle Database SQL 2:29:15

Oracle Database SQL Certified Associate (1Z0-071) Exam Practice Questions - ANALYSIS P01

Table.TransformColumns in Power 0:18:50

Table.TransformColumns in Power Query | Super Function ⚡

How to Rename 0:11:31

How to Rename Column Headings with Power Query - the quick automated way

Rename columns in 0:10:18

Rename columns in Power Query when names change | Excel Off The Grid

Unpivot Cross Tabulated 0:06:34

Unpivot Cross Tabulated Data with Multiple Headers and Columns

Rename Column Headers 0:06:14

Rename Column Headers Based on Excel Table | Power Query

Using M to 0:18:46

Using M to dynamically change column names in Power Query

Power Query - 0:07:31

Power Query - Rename Column by Position

Transform All Column 0:00:34

Transform All Column Names at once in Power Query

Combine Data from 0:18:32

Combine Data from Multiple Excel Files with Inconsistent Column Names

Expand columns with 0:07:15

Expand columns with values and nested tables in Power Query

Power Query - 0:01:45

Power Query - Combine Excel files with different sheet names

Dynamically expanding specific 1:31:40

Dynamically expanding specific columns & Optimizing code with nested let - #SaturdayWithPowerQue...

Rename Multiple Columns 0:04:30

Rename Multiple Columns with Power Query

Excel Power Query 0:10:42

Excel Power Query Tutorial - Transforming Nested Tables

Power Query - 0:08:13

Power Query - Dynamically transform column names

Комментарии
Автор

Excellent as always👍. Thanks Mark. You can save one step of promoting headers if in the first step if you set the second parameter to of Excel.Workbook to true, Excel.Workbook(File.Contents(FilePath), true, true).

kebincui
Автор

Hi great video, but in my power query I have an error that pq can't find the "Find" column and MissingField.Ignore is not working in this case. is there a way to bypass this?

MonikaFlight
Автор

Again another great tutorial. The important thing is not to measure how much the person who tells it knows (who has a lot of knowledge), but to know how to tell it in a way that the public finds out. And that totally happens. Then goal accomplished. Congratulations Mark.

IvanCortinas_ES
Автор

Can we expect 30 most useful Excel Office Scripts to automating Excel tasks? Like the VBA pdf one.

thebhaskarjoshi