I have hundreds of rows of information arranged into 4 columns:

Reference number Name Donation £ Location.
123456 C Ltd 101.50 London

I want to sort the list in to descending order of donations. In order to do
this I was going to try to combine all the info in the 4 columns into one
column then click sort descending, then split them back into 4 columns. Hope
this makes sense.

I need to know how to get 4 columns into one quickly and easily. I am not
good at excel so please instructions stupidly clear if possible. Thank you
very much in advance!

Hi,

There's no need to do that, simply select all four columns and then do your
sort on column 3 and related data on each row will sort with column 3

Mike

"Cam890" wrote:

I have hundreds of rows of information arranged into 4 columns:

Reference number Name Donation £ Location.
123456 C Ltd 101.50 London

I want to sort the list in to descending order of donations. In order to do
this I was going to try to combine all the info in the 4 columns into one
column then click sort descending, then split them back into 4 columns. Hope
this makes sense.

I need to know how to get 4 columns into one quickly and easily. I am not
good at excel so please instructions stupidly clear if possible. Thank you
very much in advance!