help sorting with commas

A

arkum

I am trying to sort data in a column in the following manner and have n
idea how.

An example of the current data in a cell is 1 a, 2 b, 1 c, 4 d, 7 e
every cell is different.

I would like it to sort the data so that the commonalities are goupe
together.

For example. All the cells that contain 1 a, 2 b, 1 c, 4 d, 7 e woul
be together and
then 1 a, 2 b, 1 c, 4 d would be together.

My boss called it comma delimited, but in looking around on this sit
that doesn't seem to be it.

Any help is greatly appreciated
 
Top