Sorting every two rows horizontally individually

[diogobr90]

Hello guys and girls,

I have a spreadsheet of 59 columns and 3000 rows that I need to do some sorting.

The rows are supposed to be groups of 2 and I need to sort this groups of 2 individually based on the first row.

Example not sorted yet,

Example sorted from smalletst to largest.

I figured how to to it in the custom sort option, but sorting these 3000 lines 2 by 2 will take too much time.

If anyone can help me with this I would be very glad.

Thank you!

 

[Joe4]

Welcome to the Board!

Can you provide some sample data, and based on that example, explain exactly how it is to be sorted?

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.