Alphacsulb
Active Member
- Joined
- Mar 20, 2008
- Messages
- 414
I've been doing this manually for a few years now and I hope this is possible to automate.
This data comes in from the customer and I have to combine their order by options. In this scenario they had 2 fields, Field0 and Field1.
Field0 order had the options ESCV and they ordered 200 of them.
Field1 order had the options ASR and they ordered 300 of them.
Here is the sample data I've described.
Sheet1
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:99px;"><col style="width:87px;"><col style="width:71px;"><col style="width:71px;"><col style="width:71px;"><col style="width:71px;"><col style="width:71px;"><col style="width:77px;"><col style="width:77px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Any leads would be appreciated.
This data comes in from the customer and I have to combine their order by options. In this scenario they had 2 fields, Field0 and Field1.
Field0 order had the options ESCV and they ordered 200 of them.
Field1 order had the options ASR and they ordered 300 of them.
Here is the sample data I've described.
Sheet1
* | A | B | C | D | E | F | G | H | I |
1 | Field0 1 | Field0 2 | Field0 3 | Field0 4 | Field1 1 | Field1 2 | Field1 3 | Field Qty0 | Field Qty1 |
2 | E | S | C | V | A | S | R | 200 | 300 |
3 | * | * | * | * | * | * | * | * | * |
4 | Desired Output: | * | * | * | * | * | * | * | * |
5 | * | * | * | * | * | * | * | * | * |
6 | Field0-ESCV | Field1-ASR | * | * | * | * | * | * | * |
7 | 200 | 300 | * | * | * | * | * | * | * |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:99px;"><col style="width:87px;"><col style="width:71px;"><col style="width:71px;"><col style="width:71px;"><col style="width:71px;"><col style="width:71px;"><col style="width:77px;"><col style="width:77px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Any leads would be appreciated.