Hello,
below I have posted an excerpt of my table. I would like to assign only the first value of Column B to the Column A value. For example, my new table should have in Column A the value P01 and in Column B the value of 100. Thereafter, P02 and 1200, then U01 and 2000, then U02 and 1500, and finally R01 and 400.
Please also consider the case of P02: As you can see from the table, the first numerical value in Column B is in the second row and not the first row. Is that a Problem?
Is there a quick way (macro?) to solve this?
Thanks so much.
<tbody>
</tbody>
below I have posted an excerpt of my table. I would like to assign only the first value of Column B to the Column A value. For example, my new table should have in Column A the value P01 and in Column B the value of 100. Thereafter, P02 and 1200, then U01 and 2000, then U02 and 1500, and finally R01 and 400.
Please also consider the case of P02: As you can see from the table, the first numerical value in Column B is in the second row and not the first row. Is that a Problem?
Is there a quick way (macro?) to solve this?
Thanks so much.
Column A | Column B |
P01 | 100 |
200 | |
300 | |
P02 | |
1200 | |
1400 | |
1600 | |
U01 | 2000 2200 |
U02 | 1500 |
2500 | |
R01 | 400 |
500 |
<tbody>
</tbody>