Hi all,
I have a list in excel that looks similar to this:
<tbody>
</tbody>
I am trying to get the list so that it looks as follows:
<tbody>
</tbody>
I was thinking I could try and remove all the numbers and then do a formula to fill the text down until it reaches the next filled cell. Anyone know how to do this or if there is an easier way? Thanks!
I have a list in excel that looks similar to this:
ROBBY |
18205 |
19206 |
GEORGE |
16573 |
ANDERSON |
23456 |
26752 |
47658 |
<tbody>
</tbody>
I am trying to get the list so that it looks as follows:
ROBBY |
ROBBY |
ROBBY |
GEORGE |
GEORGE |
ANDERSON |
ANDERSON |
ANDERSON |
ANDERSON |
<tbody>
</tbody>
I was thinking I could try and remove all the numbers and then do a formula to fill the text down until it reaches the next filled cell. Anyone know how to do this or if there is an easier way? Thanks!
Last edited: