Hi
On Sheet1 I have the following pieces of data:
<tbody>
A
B
C
1
Date
Number
Colour
2
13/09/2019
123
blue,green
3
13/09/2019
456
green,red
4
13/09/2019
789
red
5
14/09/2019
123
green
6
14/09/2019
456
red,blue
7
14/09/2019
789
red,green
8
15/09/2019
123
blue,red
9...