Dear all i need copy paste help regarding my sheet i want to copy one cell data to all blanks below it,if non blank cell came,its copy its data and paste downwaord to blankt cell in all rows. i want hi write down into below cell and then next bye into below 2 cells and like that in row
e.g
<tbody>
</tbody>
e.g
1 | Hi | 100 | ||
2 | 100 | |||
3 | 100 | |||
4 | bye | 100 | ||
5 | 100 | |||
6 | 100 |
<tbody>
</tbody>