Google Sheets: Split rows based in cell wiht comma separated values : I need to Split two rows based in the Color cell value. Each comma separated value should generate a new row.



Google Sheet link: https://docs.google.com/spreadsheets/d/1rwtSxDn_gf60xy0w63mp8Dj4bMUH9tNKJjtnsbqGzTw/edit?usp=sharing

The formula should create the rows E5:G8 form the rows A5:C6.

The formula should work with any number of rows.


[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/qYHC5.jpg