Hi, I'm trying to find a way to automate what is currently a very labour intensive process. I have a spread sheet where one cell has comma separated values. What I'd like the macro to do is separate out these values, then insert the required number of rows and transpose these separated values in to these rows.
The number of CSVs in this fixed column (column D) will alter from row to row, some might only have a single value in so nothing would need doing to those rows.
Example spread sheets are attached - a before, an after and an ideal after. Just delivering the "after" will be fine unless it's super easy to deliver the "ideal after". The CSV's in column D will not be consecutive in the actual live data or made up solely of numbers. Some might be text only, numbers only or a mixture of the two (if that makes any difference).
Any help would be hugely appreciated! Thanks!
Bookmarks