Unigue list from items in each line of list

Sorry I didnt really know how to phrase my subject line. My data is arranged like this:

Comptroller Object Code
7672AI,7672AJ,7672AK,7672AW,7672AX,7672AY
7672AJ,7672AK,7672AL,7672AX,7672AY,7672AZ
7672AJ,7672AK,7672AL,7672AX,7672AY,7672AZ
7672AI,7672AJ,7672AK,7672AL,7672AW,7672AX,7672AY,7672AZ
7672AJ,7672AK,7672AX,7672AY
7672AK,7672AY
7672AJ,7672AK,7672AL,7672AX,7672AY,7672AZ

I need a unique list of each of those 6 digit codes. Only way I can figure it is a long way around:
1) used excels Duplicate Finder to get my unique fields (for instance, in the above lines 2 and 3 match, so DupeFinder would delete one).
2) Use TextToColumns to separate each 6-digit code
3) Put them all in a column and used Advance filter to get a list of unique values.

Is there a better way?