jwalkerack
Board Regular
- Joined
- Jun 19, 2013
- Messages
- 81
Hello , I have a large Spread sheet that contains some incomplete data within one of the columns the team column see below . The of data inside the column
needs to be filled down for all the blank spaces until it reaches a cell with data
<tbody>
</tbody>
The desired output would be something like this , is there some code that could do this quickly
<tbody>
</tbody>
needs to be filled down for all the blank spaces until it reaches a cell with data
NAME | Project name | DataType | TEAM |
JACK | Player_Review | Midfielder | MAN U |
JOHN | Player_Review | Striker | |
JIM | Player_Review | Striker | |
TIM | Player_Review | Striker | |
THOMMY | Player_Review | Striker | |
JOHNNY | Player_Review | Striker | |
ALICE | Player_Review | Midfielder | ARSENAL |
MART | Player_Review | Striker | |
MARY | Player_Review | Striker | |
DEBBIE | Player_Review | Striker | |
JOAN | Player_Review | Striker | |
TONY | Player_Review | Striker | |
TOMMY | Player_Review | Midfielder | MAN CITY |
TIMMY | Player_Review | Striker | |
DINNY | Player_Review | Striker | |
JINNY | Player_Review | Striker | |
JOHNNY | Player_Review | Striker | |
DAVID | Player_Review | Striker | |
THOMAS_B | Player_Review | Midfielder | LIVERPOOL |
TONY | Player_Review | Striker | |
PAULIE | Player_Review | Striker | |
EDDIE | Player_Review | Striker | |
TREVOR | Player_Review | Striker | |
MARY_S | Player_Review | Striker |
<tbody>
</tbody>
The desired output would be something like this , is there some code that could do this quickly
NAME | Project name | DataType | TEAM |
JACK | Player_Review | Midfielder | MAN U |
JOHN | Player_Review | Striker | MAN U |
JIM | Player_Review | Striker | MAN U |
TIM | Player_Review | Striker | MAN U |
THOMMY | Player_Review | Striker | MAN U |
JOHNNY | Player_Review | Striker | MAN U |
ALICE | Player_Review | Midfielder | ARSENAL |
MART | Player_Review | Striker | ARSENAL |
MARY | Player_Review | Striker | ARSENAL |
DEBBIE | Player_Review | Striker | ARSENAL |
JOAN | Player_Review | Striker | ARSENAL |
TONY | Player_Review | Striker | ARSENAL |
TOMMY | Player_Review | Midfielder | MAN CITY |
TIMMY | Player_Review | Striker | MAN CITY |
DINNY | Player_Review | Striker | MAN CITY |
JINNY | Player_Review | Striker | MAN CITY |
JOHNNY | Player_Review | Striker | MAN CITY |
DAVID | Player_Review | Striker | MAN CITY |
THOMAS_B | Player_Review | Midfielder | LIVERPOOL |
TONY | Player_Review | Striker | LIVERPOOL |
PAULIE | Player_Review | Striker | LIVERPOOL |
EDDIE | Player_Review | Striker | LIVERPOOL |
TREVOR | Player_Review | Striker | LIVERPOOL |
MARY_S | Player_Review | Striker | LIVERPOOL |
<tbody>
</tbody>
Last edited: