Retag Thousands of Rows of Data in Seconds with Power Query

Incorrectly formatted data is the bane of a project control professionals life.   The start of a project is often a chaotic time. Everyone has competing priorities and the data naming conventions are not always clearly communicated at the start of a project.   Take for instance an example where you are receiving time sheet … Continued

Aligning Time Sheet Dates with Power Query

Handling differently formatted dates in Excel can be a real pain. This example is based on a time sheet problem that I came across. I was trying to combine time sheet data from different time sheet systems. One system cut off the weekend on a Friday of every week and the other system cut the … Continued