title: In excel is it possible to create a list of unique values from a column and copy data from another column with it?
body: <p>I have a list of data in Column B which sometimes has repeated items. In column A there is an identifier for each item. I would like to create a list that only shows 1 instance of each item and the identifier with it.</p>
  
  <p>Here is a screenshot of the list i have and the expected output:</p>
  
  <p><a href="https://i.stack.imgur.com/MmtNW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MmtNW.png" alt="Expected Result"></a></p>