Can I combine 4 columns of data into one column?
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!
|