How to order several data from different rows in one row?
 

God morning everyone,

In column D (d15:d20) I have some data - fixed values (numbers)
In Colum BL(BL10:BL5000) I have some other data - calculated values (numbers)
I want to order these data in one colum based on their values.

D BL New Colum
2 2 2
8 3 3
15 6 6
20 9 8
15 9
22 15
20
22

Data might be ordered in a new colum or the data from D colum can be added
to those of BL colum.

TIA
Tim