Excel single line becomes multiple lines.
It's simple. Insert a column before Color 2 and Color 3, both of which are named Sequence. The content is the same as the first column "Sequence", which is also pulled down from 1. Then, cut "Color 2" and the previous "sequence" to the end of the data of "sequence" and "color", and cut "Color 3" and the previous "sequence" to the end of the data of "sequence" and "color" to make it look like your second picture, and then sort, sequence and color are double sort.