Splitting raw data into separate tables in VBA : using excel and VBA:

I have a set of raw data in the following format:

**Date       | Product | Value**

30/10/2017 |    A    |  100

29/10/2017 |    A    |  100

28/10/2017 |    A    |  100

30/10/2017 |    B    |  100

29/10/2017 |    B    |  100

28/10/2017 |    B    |  100

30/10/2017 |    C    |  100

29/10/2017 |    C    |  100

28/10/2017 |    C    |  100


I need this split into separate tables A, B, C with date and value as their columns.


