I need to take multiple short lists of varying length and combine them into a single list where each item is in those lists are combined with the previous list. Specifically create a combination of all those lists to create a unique single list. I am open to macros/vb code or whatever but I have been attempting this for a month now and hope the community has a simple solution for me Thanks in advance.
Simple example below, and actual data set in attached image.
Cat Grey Healthy
Cat Grey Non-Healthy
Cat Black Healthy
Cat Black Non-Healthy
Dog Grey Healthy
Dog Grey Non-Healthy
Dog Black Healthy
Dog Black Non-Healthy
Bird Grey Healthy
Bird Grey Non-Healthy
Bird Black Healthy
Bird Black Non-Healthy
Attached is the type of datasets I will start with but have quite a few of these smart part number systems and want to get to a full list of possibilities.
Simple example below, and actual data set in attached image.
List 1 | List 2 | List 3 |
Cat | Grey | Healthy |
Dog | Black | Non-Healthy |
Bird |
Cat Grey Healthy
Cat Grey Non-Healthy
Cat Black Healthy
Cat Black Non-Healthy
Dog Grey Healthy
Dog Grey Non-Healthy
Dog Black Healthy
Dog Black Non-Healthy
Bird Grey Healthy
Bird Grey Non-Healthy
Bird Black Healthy
Bird Black Non-Healthy
Attached is the type of datasets I will start with but have quite a few of these smart part number systems and want to get to a full list of possibilities.