View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Quacy Quacy is offline
external usenet poster
 
Posts: 1
Default to convert columns to rows having mulit independent group columns

i have a list to over 1000 contacts in column form. i would like to convert
these contact into row from. Microsoft lets you convert one group at a time.
If i highlight more than one group and paste special they come up side by
side on same line.

I would like each group to come up the right side of each contact