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") :eeek: 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