I have a set of product codes that are in column A. Within the strings of product codes are skus that I would like to break out into one list of skus. The product codes are in the following format.

- A
1 PRODUCT1-OPT;Color:Silver=SKU1&Color:Blue=SKU2&Color:Green=SKU3
2 PRODUCT2-OPT;Color:yellow=SKU4&Color:Orange=SKU5&Color:Black=SKU6
3 PRODUCT3-OPT;Color:Purple=SKU7&Color:White=SKU8Color:Red=SKU9

I would like to end up with a list like this.

- A
1 SKU1
2 SKU2
3 SKU3
4 SKU4
5 SKU5
6 SKU6
7 SKU7
8 SKU8
9 SKU9