Hi All,
I have a sheet from a manufacturer that tells me which models get which rewards. It looks like this...
<tbody>
</tbody>
In order for me to use v-lookup (as I have thousands of line items), How to I transpose this so that each model shows on a different row with the corresponding value? Each model on their list is separated by a comma.
<tbody>
</tbody>
Its probably something so simple, but I cant figure it out. Any help would be appreciated.
I have a sheet from a manufacturer that tells me which models get which rewards. It looks like this...
MODELS | REWARD |
X1245, J4541, Y4154 | $15 |
A1015, N1522 | $20 |
<tbody>
</tbody>
In order for me to use v-lookup (as I have thousands of line items), How to I transpose this so that each model shows on a different row with the corresponding value? Each model on their list is separated by a comma.
MODEL | REWARD |
X1245 | $15 |
J4541 | $15 |
Y4154 | $15 |
A1015 | $20 |
N1522 | $20 |
<tbody>
</tbody>
Its probably something so simple, but I cant figure it out. Any help would be appreciated.