Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Partial correlations | Excel Discussion (Misc queries) | |||
Partial String | Excel Discussion (Misc queries) | |||
Partial input | Excel Discussion (Misc queries) | |||
COUNTIF for a partial value | Excel Worksheet Functions | |||
Partial replace | New Users to Excel |