Create table of data from original

Hi All

Thank you taking the time to read this

I have an excel file attached

1st tab is list of data
2nd tab is the desired results

If possible I would like to know the best way to achieve the desired results

I use several spread sheets which give me multiple styles / colours but give me the quantity by size, and not by style / colour has I require

I would like to be able to use the answer within these other spread sheets so need it to be flexible if possible.

Thank you in advance

Hi Kamboj

I like the answer but can you point in the right direction on how to get this result?

I have had a play and I have worked it out

Thanks again