I have a column of data (names of products) of nearly one million cells. What I'm after is a macro that sorts data in that column alphabetically a-z, 0-9 and then distributes each letter's chunk of data to its own column yielding new 26 columns, plus only one column for data where product name starts with a number from 0-9.

Can any one kindly help me with this request?
Thanks in advance.