A partial transpostion

G

Grd

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
 
T

Teethless mama

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
 
G

Grd

Thanks that works

Teethless mama said:
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
Click to expand...
 
Top