software

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

quot;chartasapquot; wrote:

gt; Hi,
gt;
gt; I have an excel sheet of data listing the customer no, name, address, zip,
gt; state, country, region, etc. I need to have this information listed by region
gt; but im not sure how i can rearrange this without needing to do it manually.
gt; 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 Backmannquot;chartasapquot; wrote:

gt; Hi,
gt;
gt; I have an excel sheet of data listing the customer no, name, address, zip,
gt; state, country, region, etc. I need to have this information listed by region
gt; but im not sure how i can rearrange this without needing to do it manually.
gt; 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
--
Richardquot;chartasapquot; wrote:

gt; Hi,
gt;
gt; I have an excel sheet of data listing the customer no, name, address, zip,
gt; state, country, region, etc. I need to have this information listed by region
gt; but im not sure how i can rearrange this without needing to do it manually.
gt; 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

quot;Kevin Bquot; wrote:

gt; Is each data element in its own column, or does each element reside on a row
gt; by itself?
gt;
gt; A B C D E
gt; F G H
gt; John Smith 123 Main Suite 1 Dallas TX 75201
gt; Region1
gt;
gt; Or
gt;
gt; A
gt; 1 John
gt; 2 Smith
gt; 3 123 Main
gt; 4 Suite 1
gt; 5 Dallas
gt; 6 TX
gt; 7 75201
gt; 8 Region 1
gt; 8
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;chartasapquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I have an excel sheet of data listing the customer no, name, address, zip,
gt; gt; state, country, region, etc. I need to have this information listed by region
gt; gt; but im not sure how i can rearrange this without needing to do it manually.
gt; gt; Can someone help? thank you!