Separating data in one cell into several cells in one column

[maaron007]

I have a large spreadsheet that currently has multiple data in one cell that needs to be in several cells in the same column. Then, I have another column of data that coincides with that data that needs to be carried down. Here is an example of what it currently looks like:

Number Job

356-4461/ 356-4462/ 353-8167/ 356-4459, 359-7608 J2907U

This is what I want it to look like:


Number Job
356-4461 J2907U
356-4462 J2907U
353-8167 J2907U
356-4459 J2907U
359-7608 J2907U

Does anyone know how I could do this?

Thanks, in advance, for any suggestions that could help.

[Pete_UK]

So you could have commas or a forward slash separating those codes? How many in each cell? Do you have multiple cells like this? It would help if you were to post a sample workbook.

Pete

[maaron007]

What is.xlsxWhat I want.xlsx
I have attached what it is currently, and what I would like to have. Any ideas? I have tried text to columns, but that will not work as I actually need all the numbers in one cell to be divided, but in the same column.