Easier to show than explain! See attached workbook where I added a pivot from your sample data.
Be as you wish to seem
Forum Rules