How do I Transpose without copying duplicates?

Giganews Newsgroups
Subject: How do I Transpose without copying duplicates?
Posted by:  TheRook
Date: Tue, 16 May 2006

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

Replies