Consolidate multiple sheets - similar or unclean data - Power Query Sections

Опубликовано: 16 Октябрь 2024
на канале: Efficiency 365 by Dr Nitin
1,084
42

Understand how and why to combine multiple pieces of data across #excel sheets into one block of data.

Download sample file
https://efficiency365.com/wp-content/...

Contents 📚

00:00 - Intro
00:27 - Create new file
00:48 - Navigator in Power Query
01:09 - Only create connection
01:16 - Edit Query
01:27 - Filter only Tables
01:44 - Remove unwanted columns
02:13 - Rename Name column
02:21 - Expand tables
02:46 - Check data types
03:28 - Load the data
03:51 - When to use Data Model
04:21 - When more data arrives ...
04:41 - Multiple tables with different formats
05:05 - Navigator
05:49 - Try Appending tables
06:22 - Problem: No Table name
06:41 - Add custom column
07:36 - Filter Tables
08:03 - Close and Load to
08:14 - One more table arrives
08:43 - Incorporate new table
08:53 - Refresh query
09:06 - DO NOT import new table
09:33 - Benefits of combining data

Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn :   / nitinparanjape  
Twitter :   / drnitinp  

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)