Split cell data in mutiple rows
Hello all,
I have a excel worksheet as :
Name Address Cost center Class
A 123 345,234 Q
B 122 34 Q
C 1 3222,34,56 Q
But now i want to write a macro so that i can separate the comma values
under the cost center column into different rows,
So my output looks like
Name Address Cost center Class
A 123 345 Q
A 123 234 Q
B 122 34 Q
C 1 3222 Q
C 1 34 Q
C 1 56 Q
Can this be done with the help of macro and once i get the data in this
format , i need to run some other macros too, so i want it into the
same worksheet if possible
Thanks
|