Here is my question: I have two cells, side by side on the same row.
One has an amount in it, the other has a list of names, comma
delimited. I need to transpose the names so that there is one row per
name, with the amount next to it (same amount for each row). How can I
start this going? Thanks much.