Sorting

  • Thread starter Thread starter Ber
  • Start date Start date
B

Ber

I have the following data sample. I need to sort by Style, keeping th
proper location.
A B C D
1 Style Location Style Location
2 Abby A11 Dare B11
3 Emma A21 Lisa B21
4 Kiki A31 Mo B31


The result should be like this:
A B C D
1 Style Location Style Location
2 Abby A11 Kiki A31
3 Dare B11 Lisa B21
4 Emma A21 Mo B31

How can I do this on all the worksheet?
Thanks
 
Ber:

You can select columns A & B (starting with row 2), copy
them and paste elsewhere (on the same sheet or a
different worksheet); then copy columns C & D similarly;
paste them in the next row below what you just pasted;
select all, then sort as you wish, and take 1/2 of the
sorted data for columns A & B, copy/cut and paste, then
grab the rest and paste in columns C & D.

JR
 
Back
Top