Hi,
I was just having a go at this, not sure it's the best way but it's one way you could potentially do it....
In Cell B2 - copy down....
In cell C2 - copy down...
In cell D2 - copy down...
In cell E2 - copy down...
I didn't go any further as it kind of depends how many columns this could go up to if it would be worth it, using this method the formula is different for each column, I don't know how to write one that would work for all columns. What is the max possible number of commas in one of the cells in column A?
I suspect someone else will come up with a better way to do this but there's my input so far.
Bookmarks