I have a bunch of data in one sheet (we'll call it 'RawData') and need to auto-populate Column A in Sheet2 based on Column G in RawData.

Column G in RawData has a list of applications (with some repeats).

Column A in Sheet2 is blank, but I want it to list all of the applications in Column G in RawData in alphabetical order, with no repeats (I want to count the occurances by date, but I have that figured out already). I want Column A in Sheet2 to automatically update and add applications if applications are added in Column G in RawData.

Is this possible?

Thanks!