I want to create table showing the location of my samples.
The samples are unique numbers in column 1 and can only be in one location. The location is another column, there can be up to 20 locations and any number of samples can be in a location.

I have tried using IF but it leaves blanks if the condition is false and I dont want blanks.
Any help would be appreciated.