Inverting a set of data

[simac]

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.

 

[Stefi]

Maybe sort both columns in descending order and move column A after column B!
Regards,
Stefi


„simac†ezt írta:

 

[simac]

Sorry, my example was inapropriate.

The order in which column A & B are in can not be changed as these represent
a point on a path:

A B
4687 30033
30033 77258
77258 30686
30686 30034
30034 30035
30035 30449
30449 4689

To sort sort them using assending/decending order would also change this
path. Basicly I need the path to run backwards starting at 4689 in cell A1.

 

[Stefi]

In C1 enter =ROW(),
fill it down to the end of your table,
copy column C and PasteSpecial/Values on itself,
select range A1:Clastrow,
Data>Sort by column C in descending order,
select column A,
right click on the right border,
drag it after column B,
choose shift to the right and move,
delete column C.

Stefi


„simac†ezt írta:

 

[simac]

Cheers, worked a treat

In C1 enter =ROW(),
fill it down to the end of your table,
copy column C and PasteSpecial/Values on itself,
select range A1:Clastrow,
Data>Sort by column C in descending order,
select column A,
right click on the right border,
drag it after column B,
choose shift to the right and move,
delete column C.

Stefi


„simac†ezt írta:

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„simac†ezt írta: