Excel split data and output all combinations.

I have list of data and want to know how to process data the way I want it?
Please have a look at file, there is a sample output.
-diameter.xlsx
LVL 16
SSupremeAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
Try attached.
Accept macros, and press button to run.
-Split-diameter.xlsm
1
 
SSupremeAuthor Commented:
Thanks! It works!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.