It's amazing how one can take pivot table data -- double-click
in the data section and it "converts" the PT format to a data-table format
(fit for a database environment, say access)...
Well any way, I receive files that are in a sort of a crosstab format,
which I'd love to be able to get to respond to (the creation) of a Pivot
table.
Is there a way to make this "conversion"?
Thanks in advance for any direction offered..

Do you mean something like this:
http://j-walk.com/ss/excel/usertips/tip068.htm
from John Walkenbach's site.

Jim May wrote:

It's amazing how one can take pivot table data -- double-click
in the data section and it "converts" the PT format to a data-table format
(fit for a database environment, say access)...
Well any way, I receive files that are in a sort of a crosstab format,
which I'd love to be able to get to respond to (the creation) of a Pivot
table.
Is there a way to make this "conversion"?
Thanks in advance for any direction offered..

--

Dave Peterson

Dave, This is exactly what I needed. I hesitated before I asked, but
certainly
am now glad I forged forward with the Q...
Thanks again for the reference to JW's Site and solution.
Have a good one,
Jim


"Dave Peterson" wrote in message
...
Do you mean something like this:
http://j-walk.com/ss/excel/usertips/tip068.htm
from John Walkenbach's site.

Jim May wrote:

It's amazing how one can take pivot table data -- double-click
in the data section and it "converts" the PT format to a data-table
format
(fit for a database environment, say access)...
Well any way, I receive files that are in a sort of a crosstab format,
which I'd love to be able to get to respond to (the creation) of a Pivot
table.
Is there a way to make this "conversion"?
Thanks in advance for any direction offered..

--

Dave Peterson