I have to repeatedly build tables in Excel, write a bunch of COUNTIFS and then load that data into PowerQuery and unpivot it.
Does anybody have a way to do this quickly/automatically and in a repeatable manner? I've attached an example here where I have Start/End dates and I want to know how many lines were active in each month.

Bonus points if we can do it without M, but understand if that's the only way (I'm not an M coder).
Does anybody have a way to do this quickly/automatically and in a repeatable manner? I've attached an example here where I have Start/End dates and I want to know how many lines were active in each month.

Bonus points if we can do it without M, but understand if that's the only way (I'm not an M coder).