Random Sorting Data

[Sharp]

I have 2 columns of data with over 1000 rows. Does anyone know how i can simply change the SKU's at the end to the Sku's at the top. For example, here is a small section of the data

4380 10
8620 4
1244 7
4263 2
2930 7
3158 2
1124 8
3953 9
1468 3
3532 1


I want the data above to change to the data below...is there anyway to invert it????

3532 1
1468 3
3953 9
1124 8
3158 2
2930 7
4263 2
1244 7
8620 4
4380 10

[NBVC]

Assuming your data is in A1:B1000....

Try (in adjacent column):

=OFFSET((A$1:A$1000),MAX(ROW(A$1:A$1000))-ROW(),0)

This formula is an array formula and must be confirmed with CTRL+SHIFT+ENTER not just ENTER. You'll see { } brackets appear around the formula....then you can copy it down 1000 rows and over 1 column....

adjust ranges to suit....

If you want to replace your original data after...then copy these 2 new columns, click on cell A1 (or top left cell of original range) and go to Edit|Paste Special and select Values. Click Ok... Now you can delete the columns with the formulas.