消除重复并列出单个单元中的第二列

I have a large set of data (40,000+ rows) and it is all multiple id numbers. They are listed in column 1. Then in column 10, i have a SsoftGroup name for multiple job posts they qualify. I would like to take what I have and pull to a separate tab the data that I need...I have a large set of data (40,000+ rows) and i