Originally Posted by

**Ron Coderre**
Try this...

Assuming you have 2000 columns of data, in B2:BXY1000

If there isn't a blank row above your data, insert one

Then...

•Beginning in the blank cell above the first data column (B1),

enter a series from 1 through however many data columns you have

(in my example the series is 1 through 2000 in B1:BXY1)

•Copy that series

•Paste it to the right of the series, beginning in BXZ1

•Select all of the data, including all of the numeric series

•From the ribbon:

•••Home.Sort_&_Filter,Custom_Sort

••••••Click: options.Sort_left_to_Right....Click: OK

••••••Sort by: Row_1

••••••Sort by: Values

••••••Sort by: Smallest to largest

••••••Click: OK

Since the number series has two 1's, two 2's, etc...

blank columns will be sorted into your data.

Is that something you can work with?

## Bookmarks