From Pivot tables back to Excel

[Justin810]

I'm sorry in advanced if this has been covered before, or has an obviou
answer.

A client of mine has been providing me with contact data through Exce
2003 pivot table. The address "cell" contains address 1, address 2
city, state, and zip. When you click on it, you the the option o
viewing each of the aformentioned individually.

My question is, is their a way to convert this pivot table back into a
excel sheet where the address cell is broken down into multiple columns
I'm not sure why my client choses to provide this information to u
this way. Perhaps this is the way it gets uploaded from thei
database

 

[Zoddy]

The original data is usually on another worksheet - try hunting in the other sheets

 

[Guest]

It's hard to understand exactly what you're trying to do, but I think I get
it. If you click on the header of the data area of the pivot table, and drag
it directly to the right, and drop it, it should distribute the data across
several columns, rather than bunching it in 1 column. Hope that helps.