Create a standard table from pivot table data

[jaaret]

I have inherited an Excel pivot-style table with about 550 rows of courses and almost 300 columns of job titles. The point where they intersect lists whether the course is required, recommended, elective, or n/a. Is there a way to automate getting this data in a standard Access table without rey-keying it?

 

[SkipVought]

faq68-5287

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[jaaret]

Fabulous! I saved the 2007 .xlsx file as a 2003 .xls file, moved it to my laptop with Office 2003 and the pivot table trick worked - almost. The 65,536 row limit couldn't accommodate all of the 162,000+ data points in the pivot table.

Does the new pivot table interface in Excel 2007 have this capability? If so, I can't figure it out. Can you point me to step-by-step instructions?

 

[SkipVought]

Have not tried this process in in 2007, which I avoid like the swine flu.

But you can activate the PivotTable Wizard in 2007, which I have done, using standard keyboard shortcuts...
[tt]
alt+D
alt+P
[/tt]
once you have activated the PTW, use the published approch.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}