PQB02: Power Query Basics-Extract data from current workbook, and creat dynamic unique list
Excel Data Analysis Series: PQB: Power Query Basics
Pqb02: Extract data from the same workbook
3 ways with 3 examples:
From an un-named range
From a named range
From a table
See also how to:
Remove columns - and remove other columns
Change Data Type
Create dynamic unique list (remove duplicate rows)
Delete/change applied steps
Refresh queries
Update queries with new data
Combine query output with excel functions
To watch the full playlist
• PQB :Power Query Basics
To watch the video about formulas in tables and structured references:
• Video #8: Structured Reference
To subscribe to the channel:
/ @aaaexcel
To Download the excel files:
PQB02Completed:
https://drive.google.com/open?id=1z7X...
PQB02Start:
https://drive.google.com/open?id=1G1d...
To follow on Facebook:
/ excelispower
To follow on LinkedIn:
/ amratef