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!
Bookmarks