Hi
Pretend I've got
01/01/2000 - 01/01/2004 33 players in squad
01/01/2004 - 01/01/2007 25 players in squad
01/01/2007 - 01/01/2009 25 players in squad
01/01/2009 - 01/01/2012 47 players in squad
With how it didn't really change on 01/01/2007, is it difficult to write a query that would condense this to:
01/01/2000 - 01/01/2004 33 players in squad
01/01/2004 - 01/01/2009 25 players in squad
01/01/2009 - 01/01/2012 47 players in squad
I've uploaded a spreadsheet with another example
Thanks
Pretend I've got
01/01/2000 - 01/01/2004 33 players in squad
01/01/2004 - 01/01/2007 25 players in squad
01/01/2007 - 01/01/2009 25 players in squad
01/01/2009 - 01/01/2012 47 players in squad
With how it didn't really change on 01/01/2007, is it difficult to write a query that would condense this to:
01/01/2000 - 01/01/2004 33 players in squad
01/01/2004 - 01/01/2009 25 players in squad
01/01/2009 - 01/01/2012 47 players in squad
I've uploaded a spreadsheet with another example
Thanks