Redistribute a Delimited Column Of Data into Separate Rows (Keeping Other Data As Is)

[Trosko]

You can select the range of cells in question and then use ctrl+F and the Replace All function to look for blanks and replace with NULL. Then run the original macro without the code that deletes the blanks.

Thanks! I knew there would be something really easy that I wasn't thinking of.