how to write a formula to add the "Product" field (New Column) to each entry under the same sub-group to create a new table (see below), your help is highly appreciated & thank you very much
<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Source Table | ||||||
Product-Order | JAN | FEB | MAR | SUBTOTAL | ||
Apple | 2 | 4 | 6 | |||
ord-1001 | 2 | 2 | ||||
ord-1004 | 1 | 1 | ||||
ord-1301 | 3 | 3 | ||||
Oranage | 4 | 5 | 9 | |||
ord-1009 | 4 | 4 | ||||
ord-1100 | 5 | 5 | ||||
Kiwi | 2 | 6 | 7 | 15 | ||
ord-11102 | 1 | 1 | ||||
ord-1201 | 2 | 2 | ||||
ord-11109 | 4 | 4 | ||||
ord-12010 | 7 | 7 | ||||
New Table | ||||||
Product | Order | JAN | FEB | MAR | SUBTOTAL | |
Apple | 2 | 4 | 6 | |||
Apple | ord-1001 | 2 | 1 | |||
Apple | ord-1004 | 1 | 3 | |||
Apple | ord-1301 | 3 | 4 | |||
Oranage | 4 | 5 | 9 | |||
Oranage | ord-1009 | 4 | 5 | |||
Oranage | ord-1100 | 5 | 5 | |||
Kiwi | 2 | 6 | 7 | 15 | ||
Kiwi | ord-11102 | 2 | 2 | |||
Kiwi | ord-1201 | 2 | 2 | |||
Kiwi | ord-11109 | 4 | 4 | |||
Kiwi | ord-12010 | 7 | 7 | |||
<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>