View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default copy & past row to column

I want to copy a row of data and past it into a column. however i only want
to pick up every other cell or every third cell. for instance i have names
going across the row but thier are a few columns in between each name and i
want to past the names like a list in one colomn. I also want to past parts
of the data for each name in that same format. Any idea for the easiest way
to handle this?

thanks