Ashish, thanks for your help.

The formula you provided returns on data -- the cells are left blank.

To clarify, I have data in Column A, and I want to Copy that data into Colum
B but without blanks. Do you have an alternative suggestion?

Thanks very much for your time.


"Ashish Mathur" wrote:

Hi,

You may want to try the following formula

In range F1:F10, enter the number 1:10

In cell D1, enter the following formula

=if(iserror(index($A$1:$A$9,small($B$1:$B9,F1),1)) ,€�€�,index($A$1:$A$9,small($B$1:$B9,F1),1))

Regards,

"SteveC" wrote:

I would like to convert data in Col A to a format in Col B, so that Col B
omits the blank cells in Col A. Is this possible with a formula I can drag
down? For example:

Col A Col B
1 1
2
2 34
34 5
5 6
9
6 7
9

7