Forum

By the way, my process was as follows: the step before the Grouped Rows step, I added a custom column and pasted your formula you gave me: = if Text.C...

I inserted a step before the Grouped Rows step by got the following error: Expression.Error: We cannot convert the value null to type Text. Detail...

OK here is a sample file. As far as the logic goes, that's what I don't have experience writing, but if I had to take a stab, it would go something li...