A partial transpostion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LINEST multiple known_x's separated arrays 5
Traspose Column data into Row 3
transpose array of non-adjacent cells 3
Column To Rows 3
Finding multiple data values in a column 2
transposing addresses 6
macro - how to move to a specific cell and repeat 7
Multiple Numbers in a cell 3

Back
Top