Append Multiple | DATACENSE

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Power Query

Introduction to Power Query

Introduction (3:48)
Installation of Power Query (3:26)
Data Sources (2:54)
Section summary

Practice Files (Download them for practice)

Data
Clean and Transform
Append Simple
Append Multiple
Append Files - Using File Names
Append Multiple Partially Same
Append Multiple Sheets
Spit Columns
Merge
Extract from Text
Data Summarization to Reduce Size
Extract Data from Web or PDF
Dynamic Path
Misc Data

Basic Data Transformations

Remove duplicates _ blank rows (5:50)
Import data from text file (4:39)
Import data from other excel (10:23)
Remove row remove column fill (10:29)
Unpivot Columns (6:09)
Receivable data part 1 (3:13)
Receivable data part 2 (8:36)
Split column merge top row calculations (8:15)
Loading Option (5:50)

Combining Data Manually

Clean Despenser sheet (9:08)
Clean water sheet (7:05)
Append manually (7:09)

Combining Data From Multiple Files ( Append )

Append from folder automatic (6:07)
Append from folder custom steps (9:45)
Adding more files to folder (2:05)
Append from folder with sheet or file name (12:27)
Using dummy file to avoid error (4:50)
Append Multiple Files Partially Same (10:17)
Append Multiple Sheets from a File (6:16)

Text Split

Split Text to Column (7:42)
Split Text to Row (5:06)

Merge Query - An Alternative of Vlookup

Merge Query Simple (10:07)
Merge Query Multiple Columns Part 1 (11:03)
Merge Query Multiple Columns Part 2 (6:19)

Summarizing Data Using Power Query

Summarize Data Using Group By (5:56)
Pivot Column to get Multiple Columns 1 (3:46)
Pivot Column to get Multiple Columns 2 (2:52)
Extra Data from PDFs (4:54)

Teach online with

Append Multiple

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock