#PowerQuery #SQL #PowerQueryAllTheThings #PowerQueryTodasLasCosas

Topic: SQL Dynamic Pivot & Unpivot
Features: Replicating PQ pivot and unpivot other columns, fully dynamic
SQL requires some heavy hardcoding.. but not anymore!

Medium Blog: https://buff.ly/4e70qO2
Github: https://buff.ly/4e0Kj4D

#PowerQuery #CustomFunction #PowerQueryAllTheThings #PowerQueryTodasLasCosas

Advanced use of Table.InsertRows() - dynamically inserts columns
Features:
• Insert ID/KEY value
• Filler for remaining columns
• Row Position (Top/Bottom, any row)

Github: https://buff.ly/3LZwpEb