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 …

01/04/2017

I have been using Formidable Forms with WordPress on and off for about 3 years. I have a conventional SQL …

17/10/2014

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

19/12/2012

“Big data” is hot, hot, hot (Gartner hype cycle) and now supported by Amazon Web Services. Although pitched as “Big …