Hi, I have a list that contains names of some pipe assemblies but also names of some parts that are to be shipped individually.
Does anyone know how to extract a list that would list the rows with assembly names once while listing all the rows that contain "shipped loose"?

ex:
Col A (original list) Col B (extracted list)

assembly 1
assembly 1
shipped loose
assembly 2
assembly 2
shipped loose

Col B (extracted list)

assembly 1
assembly 2
shipped loose
shipped loose

Thanks for any help!