Creating new database from old cells with multiple data in a single cell for GIS/slicers

[mr_norrell]

Hi first timer here. I am trying to create a new database from some data that I already have in an excel spreadsheet and I don't know where to start and actually the problem is relatively difficult to explain too! I have multiple data attached to a value in the first cell, but would like to separate this data so that there are multiple rows and so that each row corresponds to the value in the second column. I'm posting a picture of my current situation and my desired. I'm wondering if it's possible to use a vba loop or something to copy all of the data from the second column. Thanks in advance for the help!

 

[mr_norrell]

Hi first timer here. I am trying to create a new database from some data that I already have in an excel spreadsheet and I don't know where to start and actually the problem is relatively difficult to explain too! I have multiple data attached to a value in the first cell, but would like to separate this data so that there are multiple rows and so that each row corresponds to the value in the second column. I'm posting a picture of my current situation and my desired. I'm wondering if it's possible to use a vba loop or something to copy all of the data from the second column. Thanks in advance for the help!

Here is a link to the picture:

Imgur: The most awesome images on the Internet