A partial transpostion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grd - 29 Mar 2007 14:48 GMT

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

Reply to this Message

Teethless mama - 29 Mar 2007 15:50 GMT

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

> Hi,
>
[quoted text clipped - 11 lines]
>
> Suzanne

Reply to this Message

Grd - 30 Mar 2007 04:06 GMT

Thanks that works

> Create a helper column B
> In B5: =COUNTIF($A$5:A5,A5)>1
[quoted text clipped - 18 lines]
> >
> > Suzanne

Reply to this Message