Split column of cells, each cells data is separated by commas into separate rows

For a while I have used a Macro to enable me to group cells in a column of data (separated by a blank row) and collate the vertical cells into one on the lead line of the first cell and start again after the blank row and on and on. Basically it concatenates the vertical rows of data between each blank row into a single cell. The macro used is:

Please Login or Register  to view this content.

I would like to do the opposite of this. I have a column containing cells of data separated by commas (Column A in the Example1a file), the final value in the cell doesn't have a comma after it, each second row is blank. I'd like to achieve the result in Column B in the example. I'd also like to retain all the other columns of data alongside the first row of data conained in any file which could run to Column Z?

Many thanks with any help in advance

First - please do edit your post and apply code tags to comply with our http://www.excelforum.com/forum-rule...rum-rules.html

And as of merit - try the following simple macro:

Please Login or Register  to view this content.

The output is on new sheet.