View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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!