I have a worksheet of data that looks something like this:
A B C D
Sean11 11 141 BEC
Mike22 12 323 DEC
Kate54 13 412 BRD
Kyle99 14,15 844,767 DAE,BCV
I would like a MACRO that takes any line that has multiple values (i.e. Kyle99 has both 14 and 15 in col B) and inserts a new row below it and cuts and pastes the extra value, while keeping the Kyle99 in row A. Essentially creating a new row and ensuring every row only has one value for col B, C and D.
Any help would be much appreciated!
A B C D
Sean11 11 141 BEC
Mike22 12 323 DEC
Kate54 13 412 BRD
Kyle99 14,15 844,767 DAE,BCV
I would like a MACRO that takes any line that has multiple values (i.e. Kyle99 has both 14 and 15 in col B) and inserts a new row below it and cuts and pastes the extra value, while keeping the Kyle99 in row A. Essentially creating a new row and ensuring every row only has one value for col B, C and D.
Any help would be much appreciated!