I have a database in which the most part of cells have multiple data inside. So what i need is something that split every cell into multiple rows. I found different VBA codes that solve similar problem, but mine is different. In fact, for most of the cell, if a cell has only one value it should not be copied to the new rows that has been created. But for specific column i need the values to be copied in every of the rows in which the cell is splitted. Any help would really be appreciated Thanks


How it is

Name code date

a 1 2003


c 3

d 2004

e 5

How should it be:

Name code date

a 1 2003

b 2003

c 3 2003

d 2004

e 5 2004

  • 1
    It could be very useful to put an example of the original data and the results that you want. – jcbermu Sep 25 '15 at 10:44
  • Help us to help you. Post an example. – Gary's Student Sep 25 '15 at 11:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.