Most valuable professional
  • Hot Topics

Excel An improperly constructed table

I was just handed an Excel file with "tables" within it, however, there is no database structure to it - it is basically just a ledger - months at the top, but above that headers "merged and centered"; Categories and Subcategories on the left. I'm supposed to link (via Power Query) this data to another report and it's just impossible in the current format. Before I start the mind-numbing process of converting this manually, is there a way for Excel (or another program) to convert this to a database table? (I'm preparing/fearing the response is "spend the next few days copying and pasting") Thank you.

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of June 17, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel