Hi,

I want to transpose a list from a single column to a single row however I
only want certain items transposed not all of the list.

The items I want are the duplicates of peoples names so if a name appears
twice then I only want the second instance to be transposed into a row.

I have no clue,

Any help greatly appreciated.

Thanks

Suzanne