excel question special need
Posted on 2013-01-08
I have an excel spreadsheet with about 6 columns and 350 rows
one of the columns "C" has values separated by a ; within it
now we are told that we cannot user the multi entries separated by a ; so each one needs its own line.
and example of "C" would be A;B;C;D which now need to be three separate lines
joe Blow A;B;C;D golf
joe Blow A golf
joe Blow B golf
joe Blow C golf
joe Blow D golf
is there a way for me to automatically do this?