This PivotTable is done without a single formula to debug. )ДЇormatting color can be tweaked to provide alternating color bars and columns (by quarter) to make it easier to read. I think it has summarized all of the information you are looking for (. Regardless, the information in the visit table is sent to a pivot table that can look something like this:

In that case, the 'Count store Visits' column is also redundant. So, as you do a visit (with a date column), you enter the information.

And you might want to add a visit date column(?). I'm guessing that 'Visits based on hours' is a flag saying you have to do one or more visits during the Quarter, so the 'Q Visit' column is redundant. Starting with raw data that looks something like thisДЄlthough I wonder if the 'Q visit' and count are redundant. This is a perfect candidate for a PivotTable.ДЄctually, I would 'back you data a step' to the 'raw' data ReorderedColumns = Table.SelectColumns(ReplacedZero,outColumnOrder,MissingField.Ignore) ReplacedZero = Table.ReplaceValue(PivotedColumn,0,null,Replacer.ReplaceValue,targetColumns), Not sure I understand why you want the Qtr Visit columns with Yes/null as if you have a Count of VisitsвЂ¦ I had to fix your data (in red and green below).

Reverse transpose in excel