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

CodePudding user response：

Try this..

=Filter(B2:B,(C2:C="")*(B2:B<>""))

Filter function is one of several spill ranges that can do this.