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.