Try to create a new table to add the title to the associated entry for the group, Your help is highly appreicated

[zifu886]

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

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>

 

[zifu886]

Hi Dante,

Awesome !!! your magic macro is working perferctly. Save my days & thank you very much, Have a wonderful day

Sincerely

Zi

 

[zifu886]

Hi Sandy666,

thank you very much for your great code. Im using excel 2013, just downloaded the power query & installed. I will try the M-Code & let you Know the result. Have a wonderful day !!!

Sincerely,

Zi

 

[DanteAmor]

Hi Dante,

Awesome !!! your magic macro is working perferctly. Save my days & thank you very much, Have a wonderful day

Sincerely

Zi

I'm glad to help you. I appreciate your kind comments.

 

[sandy666]

Im using excel 2013, just downloaded the power query & installed. I will try the M-Code

good decision

have a nice day