I can perform a text to column, but is there a text to row function?

e.g., in cell a1 I have;
jane,joe,larry,moe
and in cell a2 I have;
red,blue,green,yellow

I want it to look like this;
cell data; cell data
a1 jane; b1 red
a2 joe; b2 blue
a3 larry; b3 green
a4 moe; b4 yellow

I could do it manually, but I have many hundreds of rows with 10 cells with
this data configuration. I also have to perform this task every 2 weeks.

tia,
--
JMorrell