Suppose you have a list of Values in Column A, and now you want to…