Transform multiline records into a table

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 two posts as part of the Excel For Security Analysts series (So stay tuned for some magic on SSH and...
Excel for Security Analysts – Intro

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, I had spent 14 years in developing Network & cyber Security products. Whether we had been developing...
Excel for Security Analysts – Episode 1

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 other episodes of Excel for Security Analysts go here. Web traffic logs are generated by web proxies and...