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

[Jim May]

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]

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

 

[Jim May]

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