How to use the flatten formula in Google Sheets

Test scores that are good for a spreadsheet might not be great for google data studio. You can create some calculated fields in GDS, but if you want to compare test scores over time, it is easier to have your spreadsheet set up more like a database.
Music by Epidemic Sound.

[@b.nascimento1976]

assistindo agora no Brazil. me ajudando muito! Muito obrigado pelo excelente conteúdo!! Parabéns!!
watching now in Brazil. helping me a lot! Thank you very much for the excellent content!! Congratulations!!

[@marydopamine9280]

thank you!

[@rachmathidayat9679]

What if the data increases ?

[@smithviz]

Change your formula to allow for open ranges. Instead of A2:A300, make it A2:A.