Dynamically Transform Data Type for All Columns with Table.TransformColumns

=Table.FromList( ) when working with numbers

=GROUPBY( ) 💚 Easier & Faster

How I Remove Columns by Position Number With Excel Functions

How I Calculate Running Totals, Using Power Query

How Table Schema can help you to select the columns to keep (or remove)

How To Dynamically Remove Empty Columns in Power Query

How To Work With Double Headers - Power Query

How I use the =DROP( ) function in Excel! - MS365

AGGREGATE - This Excel Function is a Real Treasure!

For Small Data Sets - VLOOKUP/XLOOKUP in Power Query Without Merging Tables

How To Dynamically Keep a Single Value Using Power Query - Bonus: Create a Custom Function!

You Can Filter Several Columns At Once in Power Query!

Are you creating the query in the same workbook? Do it fast and efficiently!

How Do You Decide =ARRAYTOTEXT( ) or =TEXTJOIN( ) ?

How to be the hero at work with Power Query & Power Pivot

Optimize Table.SelectRows for better results! #PowerQuery

Convert Text To Date And Group By Quarters - Power Query

How To Start Working With Pivot Tables In Excel

M - Lists Overview

Simple and easy transformations for a better analysis - Power Query

How I Dynamically Transform Double Column Names With Power Query

How I Replace Special Characters In a Text

Table.TransformRows or Table.TransformColumns

Replace Multiple Values With Power Query - Short Version

WRAPROWS & WRAPCOLS -You Will Love Them!!!

SEQUENCE, VSTACK, INDEX, COUNTA - Split Info From 1 Column Into 2

Split information from 1 column into 2 with List.Alternate

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

How I Automate My Bank Reconciliations With Power Query

Several Reports - One Source Of Data - #PowerQuery

Table.Split and Table.SplitAt - Power Query

Split Text By Rows With Power Query

Dynamically Adding Leading Zeros - #SaturdayWithPowerQuery

Enter Info To A Table Though a Form - Not Everyone Knows...

How To Trim Leading Zeros With Power Query - #SaturdayWithPowerQuery

How I Take 10 Rows From The Middle Of a Range Or a Table, with =TAKE( ) In Excel

How To Transform Nested Tables & Then Combine Them - Power Query

Convert A Value To Text, In a Specific Format - #ExcelQuickTips

How I Add Values Based On 2 Criteria - You Will Love It!

Example Using Text.Repeat( ) Using Power Query - Bite-Sized Tips!

Select Random Names From A List Using Power Query - #SaturdayWithPowerQuery

Filtering By A List - Saturday With Power Query

You Need To Know These Excel Tips!!!

Top Secret In Excel - DateDif( )

=Filter( ) in Excel - Here is what I DO and HOW!

How I use =Take( ) in Excel - You will love this function!

How To Create A Custom Function That Updates As The Sample Query Updates

Adding the file name to nested tables

Transforming A Column & Filtering The Nested Tables Inside - My Favourite Tips Fr Live Sessions 2022

IMPROVED Filter #s Before Expanding Tables - Power Query

PQ - How I Used Divide-Integer & Modulo To Transform My Files This Week

Filter Item Numbers Before Expanding Tables - Power Query

Easy Way To Dynamically Remove Empty Rows And Columns

Dynamically Remove Blank Cells In No Time, With Power Query

Excel.Workbook - Promote Headers

PQ - Load Info Containing Specific Text

PQ - Filter Information By Multiple Conditions

PQ - Combining Information with List.Zip & Table.FromColumns

PQ - Obtain/Change Information In Power Query, Using Excel Cells.