View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gws-mtc
 
Posts: n/a
Default Sorting/Filtering data ???


I am looking at organizing two sets of data. For example, the data in
Column A would be distance (say every 2 ft. - 0 to 10,000). Columns B
& C would have data associated with each 2 ft. increment. Another set
of data - Col. X = Distance, every 50 ft. and Col. Y = Data.

Question:

How do I take the data of Col. Y and have it match up with the
distances of Col. A without cutting and pasting every piece?

Please advise.


--
gws-mtc
------------------------------------------------------------------------
gws-mtc's Profile: http://www.excelforum.com/member.php...o&userid=33376
View this thread: http://www.excelforum.com/showthread...hreadid=532035