rearrange data

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!

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

"chartasap" wrote:

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

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
--
Kevin Backmann


"chartasap" wrote:

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

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
--
Richard


"chartasap" wrote:

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

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

"Kevin B" wrote:

> 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
> --
> Kevin Backmann
>
>
> "chartasap" wrote:
>
> > 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!