I have a set of data in Sheet 1 ( Data vs value ) . I want to consolidate the value according to its data in the same sheet. This can be done in Pivot but I am looking for an option / formula to get the result in the same sheet , instead of getting it through Pivot from other sheet .
Input E.g :
Result looking for ( in the same sheet somewhere are the right side ) :