Dividing information in a cell and adding it to new rows in all the possible combinations.

[ngabrieln]

Hi, guys!

Two columns of the spreadsheet that I'm working with contains multiple informations divided by "/". I need a way to separate this informations contained in 1 row into multiples rows in a way that it presents all the possible matchmaking possibilities between the information diveded by "/". The rest of the information contained in the row must be copied to the newly created rows.
I added images that illustrate how my spreadsheet is now and how it need to be.

My spreadsheet contains 143 rows and all of them need to be divided this way. The number of information divided by "/" in the cells vary from 1 to 5.

Let me now if I can make myself clearer!
Thanks

 

[Micron]

IMO you'd need to use recursive procedures - not my strong point for sure. I suggest you research that topic unless someone writes this for you soon.

 

[DRSteele]

Since you lack Excel 365, which has the function TEXTSPLIT, the best approach is to use Power Query. Are familiar with Excel's PQ functionality?

 

[ngabrieln]

Since you lack Excel 365, which has the function TEXTSPLIT, the best approach is to use Power Query. Are familiar with Excel's PQ functionality?

I've worked with PowerBI's PQ a couple of years ago, but never with Excel's.

 

[DRSteele]

Well, I keep trying to Split the text by delimiter and then Pivot or Unpivot or Group the columns ... alas, I can't do it. Sorry. I hope someone better with PQ stumbles by to help you.