Split comma separated entries to new rows (no VBA)
I have no acknowledge on VBA and programming and I currently have this
data in a sheet
Col A Col B 105 399, 400 207 405,406,407
What I want to do is split the comma separated entries in the second
column and insert in new rows like below:
Col A Col B 105 399 105 400 207 405 207 406 207 407
No comments:
Post a Comment