I have a data sheet like the below and i want to for each row find the corresponding X and put it into the the below.
I'm not savy with VB and my work computer has Excel 2016.
Thanks for the help.
<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>
</tbody>
I'm not savy with VB and my work computer has Excel 2016.
Thanks for the help.
Name | PD1 | PD2 | PS3 | MM5 | |
A99 | X | X | | ||
A05 | X | X | |||
A30 | X | X | X | ||
Name | Code | ||||
Formula to say | A99 | PD1, PD2 | |||
A05 | PD2, PS3 | ||||
A30 | PD1, PD2, PD3 |
<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>
</tbody>