View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Faye[_2_] Faye[_2_] is offline
external usenet poster
 
Posts: 12
Default Extract and Transpose

I appreciate both of your help. I was confused about my issue. I also
need the date associated with the row found. I can not find the
solution using pivat table. What I look for is this:

sales/
man A Date-A B Date-B
279 8965 6/27/2005 78515 6/27/2005
774 65245 4/25/2005 332566 7/4/2005
1098 22969 6/27/2005 122443 6/27/2005
1669 78669 6/13/2005 186734 6/23/2005

How do I produce this data list? Thanks again.