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.