Using Excel 2016 to unpivot data
Normal people, by which I mean those who don’t process data all day will often create data that is present …
Normal people, by which I mean those who don’t process data all day will often create data that is present …
In 2013 I published a technique to create the union of two tables in Excel. This post is still very …
I recently came across a problem that was difficult to diagnose. After I had changed the datatype in a table …
As consultants our job is to help the user and unlike the poor second line support person we usually have …
Excel tables provide a lot of support for data processing and the use of structured references can improve readability. We …
When taking existing data to put into a data warehouse one hopes that it is nicely formatted. This is seldom …
I have been importing data from Excel to SQL Server using the SQL Server Import Wizard. Usually there is no …
Calendar Tables – Why You Need One. <credit: This section was copied from Made2Mentor> What is a Date (Calendar) Table? …