Expanding Out Lists Of Text With Commas?Apr 5, 2013
So, I have a list of data like this:
Country of Origin
Obviously I can do this using text to columns and transpose but typically I'm dealing with much bigger sheets where being able to do this automatically is a big time saving.
The column with commas in it can vary in position so I'd like this to work on the cell/column that is selected.
Ideally I'd like it to work it's way down the sheet expanding out every comma separated list in the selected column in this fashion but even something that worked on the current cell would be handy.
I think roughly I need to split the cell into an array using the comma as a seperator, possibly scrub the spaces from the text, copy the row as many times as there are things in this array (using ubound?) and then transpose the array into an area starting at the selected row and going down as far as there are things in the array but a bit lost with actual implementation.
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;