I'm looking for a macro to split a table which looks like this:

Row1 aa tom,dick,harry clancy,tracy,macy x1,x2,x3
Row2 bb mary berry z1
Row3 cc jill,bill tracy,murray y1,y2

To one which looks like this:
1 aa tom clancy x1
2 aa dick tracy x2
3 aa harry macy x3
4 bb mary berry z1
5 cc jill tracy y1
6 cc bill murray y2

Thanks!