A partial transpostion
Thanks that works
"Teethless mama" wrote:
Create a helper column B
In B5: =COUNTIF($A$5:A5,A5)1
drag the Fill Handle as far as needed to copy
AutoFilter all the TRUE
select all data on column A, right click to copy, select a blank cell, right
click Paste Special, Transpose, OK
"Grd" wrote:
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
|