reg-straight table

[#1]

hi all i have few questions recording straight table and i have attached an sample pic and i want to do like that can anyone help me recording this

1.i want to get a separator for each product as shown in pic

2. i want to merge multiple rows into single like as shown in the sample pic

and both i should get in the straight table

[#2]

HI Eva

    i have not get and am trying it in the pivot table and can it is possible in pivot table

[#3]

this is my test.

Let me know if you need to adapt it.