Can I combine 4 columns of data into one column?

C

Cam890

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!
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine multiple columns 5
sorting two columns of merged cells 1
How do I combine multiple columns into just 1 column? 1
combine data 3
Merging multiple columns into one column (dynamically) 1
how can I sort a column numerically with both words and numbers i. 2
Split one cell into 4 cells without adding columns? 2
to combine wordings in two columns 3

Top