Multiple column values into single column with distinct values by ID Level
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.