huiyin9218
Board Regular
- Joined
- Aug 7, 2018
- Messages
- 53
Hi,
How do I write a code to replace cells that contains "0" in column A with the word at the top row of each 0 group?
<tbody>
</tbody>
Above is sample table and below is the output that i wish to obtain.
<tbody>
</tbody>
I would be so grateful for your help.
How do I write a code to replace cells that contains "0" in column A with the word at the top row of each 0 group?
AD | |
0 | XX |
0 | XX |
0 | XX |
0 | XX |
AC | |
0 | XX |
0 | XX |
DE | |
0 | XX |
<tbody>
</tbody>
Above is sample table and below is the output that i wish to obtain.
AD | XX |
AD | XX |
AD | XX |
AD | XX |
AC | XX |
AC | XX |
DE | XX |
<tbody>
</tbody>
I would be so grateful for your help.