How do I create a spreadsheet from print tables/pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been sent data tables in print file format and need to create a database/spreadsheet containing this info as separate line entries in order to perform several functions prior to then summing / re-pivotting. Is there a reverse pivot tabel type function that allows me to do this? I'm sure I've seen reference to this somewhere before but cannot find reference to this anywhere within help!?
Can anybody help?
 
I went looking and couldn't find. So I searched Google and found the post. I
searched John Walkenbach's site for "reverse pivot" and son-of-a-gun, there it
was.

(well, it was interesting to me!)
 
Back
Top