I need to create an ascending sort across multiple columns

Hello all!

I have multiple columns of data - varying number of columns each with varying numbers of rows. If the 1st number in column A fits between the 3rd and 4th numbers in column B, I want to move the one in column A down to the proper position and move the numbers in column B that fit AFTER the one in column a to move down, leaving a blank where the number in column A now resides. This needs to continue across however many columns are in a particular sheet and down as many rows as the data takes up.

Also, if possible, I'd like to insert 2 columns at the left side of the sheet and have the "new" column A show a list of the unique number in that row.

I'm thinking that I need to start by sorting each column, indiviually, in numeric order.

Often the sheet I'm working on is 15-20 columns and many rows long, so it's REALLY hard to eye-ball this correctly.

I know that I don't explain well in words, so I'll attach a workbook showing my original data on Sheet1 and my desired result on Sheet2.

Any help would be greatly appreciated!

Jenny

PERFECT!! I just had to make a small adjustment so it would work to the very last column. (Sometimes there are blank columns). Now it's great! You have no idea how much aggravation this will save me. Doing it manually invariably leads to errors, just from tedium.

You've made my day.

Thanks

Jenny