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

Two columns followed by single page-width column on same page 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Format column widths from one table to a separate table on same page 1
Two columns : Continuous two columns vs Parallel two Column 1
Matching data in columns 1
help with copying data from many columns into one long column 0
Merging from an Excel file with graphics 1
sorting two columns of merged cells 2

Top