Transform ANY nested table to Pivot Table with function query
Get ready to be amazed :) This is the fourth post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you...
Author: Gil Raviv
Blogger at https://datachant.com , Ex-Microsoft Senior Program Manager in Excel team, Power Query / Power BI expert, Seasoned Product and Software Engineering Manager.
Transform a nested table to PivotTable
This is the third post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you through one of the coolest data...
Back to School – Transform class schedule to PivotTable
Back to school with Excel & Power Query This is the second post in the series The Definitive Guide to Unpivot with Power Query in Excel. For today's post...
Transform already-pivoted tables to PivotTable (The Definitive Guide to Unpivot with Power Query in Excel)
This post is the first in a series of posts that will walk you through one of the coolest data transformation features in Excel. If you are not familiar with...
Excel for Security Analysts – Episode 2 – Import Multiline Logs
This article is available...
Transform multiline records into a table
In today's post, there is a nice Power Query trick to transform multiline record data into a table in Excel. I intend to use this trick quite soon on my next...
Excel for Security Analysts – Intro
(Originally published here) The demo I will share with you today is something that I was itching to try for a while. Before I joined Microsoft and Excel team,...
Excel for Security Analysts – Episode 1
In this walkthrough we will show step-by-step how to turn web traffic logs (W3C Extended Log File Format) into a powerful security analytics workbook. To watch...
#PowerQuery: New Calendar Template with Categories and better Recurring calc
I have updated the Calendar Template to include Categories and better calculation of recurring meetings. Note: This is no longer the official template...
My first blog, Chicago and Bye Bye Excel IL
Earlier this year, I published my first blog post on PowerPivotPro.com here. It was a big step for me as a new blogger, and Rob and Avi were very kind to let...
