Your code in the file, slightly tweaked gets the same result as the Pivot Table.
Pivot table is the top presentation and PQ is the lower presentation
Excel 2016 (Windows) 64 bit
|
B |
C |
3 |
Product |
Sale Dates |
4 |
a |
01/02/2020 , 06/02/2020 , 04/03/2020 , 01/05/2020 |
5 |
b |
06/02/2020 , 04/03/2020 , 01/05/2020 , 03/04/2020 |
6 |
c |
01/05/2020 , 03/04/2020 |
7 |
Grand Total |
|
8 |
|
|
9 |
Product |
What Date |
10 |
a |
01/02/2020, 06/02/2020, 04/03/2020, 01/05/2020 |
11 |
b |
06/02/2020, 04/03/2020, 03/04/2020, 01/05/2020 |
12 |
c |
03/04/2020, 01/05/2020 |
Bookmarks