VBA to Create Permutations of different rows

Hello all,

I have been looking for resources to answer this question for some time now but none have been quite exactly what I need. I am currently learning the VBA language and need some help on a simple permutation problem that will most likely requires nested loops. I need a list of every possible permutation of words in a row broken out by column. Order does matter and not every row has the same number of words in it. Any help would be very much appreciated! I have attached a sample worksheet with a sample table and then the needed output format. Thank you!

Just was wondering if anyone had any suggestions? Thank you again!

Hi, thank you for the response! I have actually seen that worksheet but the only problem with it is that I have a particularly large data set I am working with (about 16000 rows). The data sheet I posted was just meant to give an idea of the problem I was facing (I can't post the real data due to sensitivity issues). I would not be able to post each delimited text string into that worksheet individually in order to get the permutations from that worksheet.

Hey SHG,

I would love to but unfortunately, I am really not sure how. Any suggestions?