Forum Discussion

Lorenzo_Masotti's avatar
Lorenzo_Masotti
Copper Contributor
Feb 11, 2023

Order Excel Rows from one columns

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

Lorenzo

Resources