Hello,
I need a formula or macro to look for a value in one column and copies x times into a different column based on the amount of rows under that value. I have tried Vlook up and some codes but nothing has work. I have the following table
<tbody>
</tbody>
For example I want to be able to look at the grade column and copy “1111111, p” that value 4 times or as many rows are under it until it hits the next header value which will be “222222, l”. The end table should look something like:
<tbody>
</tbody>
I need a formula or macro to look for a value in one column and copies x times into a different column based on the amount of rows under that value. I have tried Vlook up and some codes but nothing has work. I have the following table
Grade | Name | Position | Date | Code |
1111111, p | ||||
1 | xxxx | | | |
2 | sdfaf | | | |
1 | asd | | | |
56 | Asf | | | |
222222, l | ||||
1 | asfa | | | |
OP | dsfa | | | |
2 | adsfa | | | |
3 | dsfa | | | |
4 | adfe | | | |
<tbody>
</tbody>
For example I want to be able to look at the grade column and copy “1111111, p” that value 4 times or as many rows are under it until it hits the next header value which will be “222222, l”. The end table should look something like:
Grade | Name | Position | Date | Code |
1111111, p | ||||
1 | xxxx | 1111111, p | | |
2 | sdfaf | 1111111, p | | |
1 | asd | 1111111, p | | |
56 | Asf | 1111111, p | | |
222222, l | ||||
1 | asfa | 222222, l | | |
OP | dsfa | 222222, l | | |
2 | adsfa | 222222, l | | |
3 | dsfa | 222222, l | | |
4 | adfe | 222222, l | | |
<tbody>
</tbody>