Hi
I need to loop through a column and based on whether the value starts with a number, copy this value to the cell to the right of it and append any cells below it which are not numeric and then repeat when you find a cell where the first value is numeric again... to get the results as per below.
<tbody>
</tbody>
Many Thanks
I need to loop through a column and based on whether the value starts with a number, copy this value to the cell to the right of it and append any cells below it which are not numeric and then repeat when you find a cell where the first value is numeric again... to get the results as per below.
9b34 test | 9b34 test These are just words |
These are just words | |
1uy8 some more bits | 1uy8 some more bits Cells and stuff here more text and again |
Cells and stuff here | |
more text | |
and again | |
6h89 cell | 6h89 cell there it is |
there it is |
<tbody>
</tbody>
Many Thanks
Last edited: