Using Excel 2016 to unpivot data

03/04/2017

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

Create the Union of two tables in Excel revisited

03/04/2017

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

17/10/2014

I recently came across a problem that was difficult to diagnose. After I had changed the datatype in a table …

29/06/2014

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

14/03/2013

Excel tables provide a lot of support for data processing and the use of structured references can improve readability. We …

13/03/2013

When taking existing data to put into a data warehouse one hopes that it is nicely formatted. This is seldom …

07/02/2013

I have been importing data from Excel to SQL Server using the SQL Server Import Wizard. Usually there is no …

04/01/2013

Calendar Tables – Why You Need One. <credit: This section was copied from Made2Mentor> What is a Date (Calendar) Table? …