Relative Content

Tag Archive for excelsortingpowerqueryexcel-2016m

Sorting issue when consolidating monthly data into a year to date file. Using query, sorting by day, time, and letter

I am collecting data from each month on measured parts into a single file for the whole year. When using a “query from folder” I am able to get all the data together, formatted, and sorted with one exception. Every part has an “A” and a “B” version. Unfortunately, due to production order, sometimes the “B” part is measured before the “A” part. In this case I would not want to sort by time as the order would then go, for example, A,B,A,B,B,A,A,B,A,B. I want it to always place the “A” part before the “B” part. Parts are measured twice per day so I cannot sort by day and then part letter because it would then go, for example, A,A,B,B,A,A,B,B. How can I sort the data such that it goes by day, then time, then overwrites time to keep the A,B,A,B pattern?