I have two colunms of data. Coloum A contains the departments within the
organisation, column B the employees.

What I am wanting to do is transpose column A onto a row but doe not want to
display any duplictes. I have tried using the paste special but that copies
all.

The only way I have found but it is a bit long winded, is to create a pivot
table and dorp the departments into the 'drop column field' then copy and
paste values, deleting all the titles and borders.

There must be a simpler way?

The Rook