I have a range of numbers (1-20) in multiple columns, but only 6 of them are
used in a particular column. As an example col1 would have 1,2,5,8,9,15;
col2 would have 6,7,8,10,15,20; etc. Since the numbers are entered in their
corresponding cell location (ie 1=B1, 2=B2, 5=B5, etc.) there are empty cells
between the numbers in the columns.

Is there a function that will take the numbers from each column, and parse
them to a range of six cells in another area of the spreadsheet? I'm looking
to have excel copy the numbers that have been entered, to another range and
not have blank cells between the numbers.

Thanx in advance...