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!