Hi

I have data in the format (two columns)

Column A Column B
a abc, xyz, ghi, klm


Assuming my starting cell is top left "a" - what I'd like to do is:

- copy the existing row into all rows below that have a blank in column A
- move to column "B"
- convert the comma separated cell into columns (comma is delimiter) - overwriting the current cell
- copy all non blank cells created in the current row(including the cell in column 2 and all cells created to the right)
- transpose and paste those cells at the current cells
- move back to column A

end result would look like this:
Column A Column B
a abc
a xyz
a ghi
a klm


Any help appreciated

Ian