How to populate values from 2 columns in excel to a virtual pivot table (sort of a 2 dimensional dynamic array) using vba.
An example of the desired result is attached as an xlsx file
Example.xlsx