title: Easy way to normalize Excel worksheets?
body: <p>I have several fairly good-sized Excel worksheets (indexed by <code>WorksheetID</code>) that essentially amount to flat database tables:  rows are the records (indexed by <code>DataRecordID</code> within one worksheet), columns are the fields (indexed by <code>DataFieldID</code> within one worksheet), and the cells contain the field values (<code>Value</code>) for the appropriate records (or are blank).</p>
  
  <p>I'm interested in breaking them apart to (many) records like this so that I can import them into MS Access:</p>
  
  <p><code>ID  |  WorksheetID  |  DataRecordID  |  DataFieldID  |  Value</code></p>
  
  <p>I've already done this manually.  I see that it's probably a straightforward matter to write a VBA script to chug through the sheets and (optionally) delete the records in the final table.</p>
  
  <p>My question is: Before I roll up my sleeves and begin coding, is there already a built-in capability in Excel 2010 that I don't even need to write a script to do this?</p>