I have a list of data that can be seen in this example:
CodePudding user response:
For column B, put in C1
=ArrayFormula(lookup(row(B:B),row(B:B)/if(B:B<>"",1,0),B:B))
I have a list of data that can be seen in this example:
CodePudding user response:
For column B, put in C1
=ArrayFormula(lookup(row(B:B),row(B:B)/if(B:B<>"",1,0),B:B))