Hi,

You may want to try something like this

1. In one row below the last row I.e cell A52, enter max(A1:A50) and copy to
the right;
2. Now highlight the header row I.e. A1:G1 and copy it;
3. Select cell A55 and say Edit Paste Speical Transpose. Say the
headings get pasted in A55:A61
4. Now highlight B55:B61 and array enter (Ctrl+Shift+Enter)
=transpose(A52:G52)

Hope this helps.


--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"vsoler" wrote in message
...
My problem is the following:

I have a rectangular range of values. They represent the coefficients
of allocation of costs from origine cost center to destination cost
center. Where no allocation is necessary, I have an empty cell. The
range is rather empty, because the number of cost allocations is
limited (it is a sparse range).

Say columns and rows are numbered from 1 on.

1 2 3 4 5 6 7 8 9 ... n
1
2 .65
3 .7
4
5
6
7 .8 .15
8
9 .3
...
m

I want to obtain a vertical list of cells with the coefficients that
exist, thus without the blank cells

In our case, from left to right, from top to bottom:

1 .65
2 .7
3 .8
4 .15
5 .3

How can I do this?