|Subject:||How do I Transpose without copying duplicates?|
|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
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?