Batching sequential rows that are "like groups" with a formula
Here's what I want to do. Column A has values that I want to group by rows, as shown in Column B. So the first group of "x" rows is a "1", the second group of "y" rows is a "2", alternating as shown.
This is a lot of data so I can't have infinite helper columns.