How to use the flatten formula in Google Sheets

[@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!!

[@fernandoolimpio8498]

another brazilian guy congrats you for this excellent work. It helped me a lot to format google sheets files for datastudio! Thanks!

[@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.