Video#7:Power Query basics: get, transform, and load data from Table/Range
Power Query Basics: How to
Launch Power Query
Get Data from Table or Range
Load your Data back to Excel Table
Transform your Data including:
*Format & Trim Text
*Change Data Type
*Split columns
*Merge columns
*Remove duplicates
*Un-Pivot Cross Tab (Convert Cross tab to tabular or columnar)
Load Data to a new or existing work sheet
Load Data to the DATA MODEL
Only create connection