How to add a row number to an Excel table 2020 using Power Query Editor

18/04/2020

Back in 2013 I wrote post on how to add a row number to an Excel table. This post is …

Power Query: How to load only fresh rows and create an Excel history table

23/04/2018

I have previously written about the powerful ETL (Extract, Transform and Load) functions that are now in Excel Office 365 …

18/03/2018

Excel 365 Get and Transform Data (was Power Query, actually ETL) allows you to use the M language to create …

18/03/2018

I have previous blogged on how to unpivot data using Excel and Excel 365 (was Excel 2016) just keeps getting …

03/04/2017

Normal people, by which I mean those who don’t process data all day will often create data that is present …

03/04/2017

In 2013 I published a technique to create the union of two tables in Excel. This post is still very …

16/05/2016

Excel 2016 has a lot of new features to wow the power user including support for cascading IF statements and …

23/11/2015

I help run an underwater hockey club. To smooth administration I wanted to create an mobile application to record attendance …

29/06/2014

As consultants our job is to help the user and unlike the poor second line support person we usually have …