rearrange data

C

chartasap

Hi,

I have an excel sheet of data listing the customer no, name, address, zip,
state, country, region, etc. I need to have this information listed by region
but im not sure how i can rearrange this without needing to do it manually.
Can someone help? thank you!
 
B

Bob Umlas, Excel MVP

Click on one cell in the Region column, then click on the Sort Ascending
toolbar button or use Data/Sort
 
K

Kevin B

Is each data element in its own column, or does each element reside on a row
by itself?

A B C D E
F G H
John Smith 123 Main Suite 1 Dallas TX 75201
Region1

Or

A
1 John
2 Smith
3 123 Main
4 Suite 1
5 Dallas
6 TX
7 75201
8 Region 1
8
 
R

Richard

First make a backup copy. I've seen spreadsheets get mixed up after a sort
went wrong.

Click a cell in the Region column
Click Data
Click Sort...
Choose the Sort by column (Region)
Choose Ascending or Descending
Choose whether you have headings on the first row
Click OK
 
C

chartasap

Hi Kevin,

each data resides in its own column...just like your first example...when i
use pivottables it tries to do calculations (count and sum) which i dont
need...i just need to categorize the information by region
A B C D E F
name address city state zip region
 
Top