rearrange data

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!

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!