Multiple column values into single column with distinct values by ID Level

[venkyraj]

Here the ID(1) is having Type_1 as A  and  Type_2 as  B and Sales is 100(we need to sum up as 100  for each presentation) but will have one more new row for B for Type_2 then Sales will be 100*2 instead of 100,No of ID will be 3 instead of 1.

Data Set