Hellooo I need help ;'(
How do you make the result such that the all values in the column beside the adjacent empty column be listed out like this?
I dont mind if its coded inside the app script too. I just need a guide to know how to do that
Try this..
=Filter(B2:B,(C2:C="")*(B2:B<>""))
Filter function is one of several spill ranges that can do this.