mardi 31 mars 2015

How do I take a list of 8 digit numbers in an Excel, and give each digit its own row?

Suppose I have an Excel list of numbers {12345, 12354, 12435, etc...}. I want to output a list that has one row for each digit {1,2,3,4,5,1,2,3,5,4,1,2,4,3,5, etc...}.


Open to any suggestions!


Edit: (From comments)

Sample Data:

enter image description here


Result:


enter image description here


Aucun commentaire:

Enregistrer un commentaire