View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GollyJer GollyJer is offline
external usenet poster
 
Posts: 10
Default What's the fastest way to push this data around?

How would you most efficiently convert this table:

Date1 Ticker1 T1Price1
Date2 Ticker1 T1Price2
Date3 Ticker1 T1Price3
Date4 Ticker1 T1Price4
Date5 Ticker1 T1Price5
Date1 Ticker2 T2Price1
Date2 Ticker2 T2Price2
Date3 Ticker2 T2Price3
Date4 Ticker2 T2Price4
Date5 Ticker2 T2Price5


To look like this:

Ticker1 Ticker2
Date1 T1Price1 T2Price1
Date2 T1Price2 T2Price2
Date3 T1Price3 T2Price3
Date4 T1Price4 T2Price4
Date5 T1Price5 T2Price5


Thanks.
-Jeremy