Conversion of Cross-Tab Formatted data to qualify for Pivot Table

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" <[email protected]> wrote in message
news:[email protected]...
> 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