I have an urgent need to simplify a large dataset I am working on.
As you can see in the attachment (tab CDXD1Y23B-Panel), the layout of the worksheets is pretty complicated.
I need to strip hundreds of worksheets in a large workbook into a simple csv format as seen in the attached example (tab Combined Output CSV).
This started with thousands of files in xls format, and I figured out how to roll all of the worksheets into a giant workbook, but have no clue whatsoever on how to convert this data.
Any help would be most greatly appreciated.