A partial transpostion
 

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

A partial transpostion
 

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

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