View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
simac simac is offline
external usenet poster
 
Posts: 3
Default Inverting a set of data

Hi, I'm going through a large data base and need to invert the data so the
reverse route is shown.

A B A B
e.g. 1 2 6 5
3 4 4 3
5 6 to 2 1

Is there a quick way of doing this either through a formula or function that
anybody knows?
Any help would be greatly appreciated.