15 подписчиков
37 видео
Reverse the Names in Excel using LAMBDA helper functions MAP and REDUCE
Dynamic Method to Rename Column Names - Power Query
Normalization of Table in Excel using LAMBDA Helper Function REDUCE.
Unstack Rows into Columns in Power Query
How to Extract Substring using TEXTAFTER and TEXTBEFORE Function
Remove Blank Columns in Dynamic Way using 2nd Argument in Table.Profile Function in Power Query
How to Transform Cross Tabulated Table - Unpivot, Transform and Pivot Power Query
Highlight Max and Min Value in Column Chart - Excel
Extract Year, Month and Day from Date using TEXT function - Single Cell Formula
Replace Values of Multiple Columns in One Step using Table.ReplaceValue Function - M Code
Generate Multiple Columns from One Column Table based on Data Type - Power Query
Reverse Each Column of a Table - Power Query
Replace Multiple Values in One Step - Power Query
Split Text in Excel using TEXTSPLIT Function
Columns Argument in Table.FromRows, Table.FromColumns and Table.FromList Function - Power Query
