long list of rows like the one in the attached in row 1.
i need to split it into two rows as i did in the below cells. sometimes three rows if there are 3 entries in column C separated by col.
as you can see 1st entries in C,D,E go into their own new row. 2nd entries go into a new other row