Order Excel Rows from one columns

Copper Contributor

I need to find the right way to reorder rows and columns without separating columns from their original rows entering the order for a single column from the smaller to the bigger. I think without attaching or chaining rows and columns the new value of the orderd columns would be detached from the right rows.



For example


 I have these rows and columns


 1)Material  2)Mass 3) Density and 4)Conductivity

and each time I put in this table new values from exteranl source of new material with specifical values of each of them. 


If I would like to reorganize all these materials from the density to the smaller upto bigger, how can I avoid to reorder just column of density and replace the other subject from their original rows of material?


Thank you for everyone so patient to help me

Kind Regards


4 Replies



In Excel for the web you can try this formula.

sort by density.JPG


An alternative could be Power Query. In the attached file you can add data to the large blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.


Hei, right which version is this one? I may have to change from Office 2016, thank you!


The Power Query suggestion is done with Excel 2013.


For DATI.ORDINA.PER you need Office 365, Excel 2021 or Excel for the web.

Funzione DATI.ORDINA.PER - Supporto tecnico Microsoft