Hi, I know how to extract a unique list but not sure how to extract for specific columns. I am trying to extract, exclude spaces and sort a unique list from MasterDataEntry sheet with App Owner (Column 2) and Name (Column 3) for all systems. The unique list need to be extracted in Legend worksheet, column L.
Attached is the sample data. Please assist to solve this issue? Thank you.
Bookmarks