Nerdery,
I do not post here often but lurk quite a bit and know there are some excel users much better than myself. So I am working with a Lease Operating Statement (If not familiar with O&G, kind of like a Profit and Loss). The way the software outputs the data is a spreadsheet, about 60,000 rows. It is the same "table" recurring every 148 rows. To throw a curve ball, rows are not full to just pivot, and there are row "breaks" with headers, etc, since it is exporting 3 "pages" per "table".
To explain this better:
"Table" 1 is B13: O145
"Table" 2 is B161: O293
... to row 57688
There are breaks/empty rows within these tables, all recurring at 148 rows.
What is the best/easiest way to get this this condensed to be able to pivot, or any other way to where it is workable? This will be something I battle quarterly, so having a better solution than deleting stuff out to be continuous would be much appreciated. If yall need visual aid, let me know, I would have to scrub some stuff.
Thanks in advance
I do not post here often but lurk quite a bit and know there are some excel users much better than myself. So I am working with a Lease Operating Statement (If not familiar with O&G, kind of like a Profit and Loss). The way the software outputs the data is a spreadsheet, about 60,000 rows. It is the same "table" recurring every 148 rows. To throw a curve ball, rows are not full to just pivot, and there are row "breaks" with headers, etc, since it is exporting 3 "pages" per "table".
To explain this better:
"Table" 1 is B13: O145
"Table" 2 is B161: O293
... to row 57688
There are breaks/empty rows within these tables, all recurring at 148 rows.
What is the best/easiest way to get this this condensed to be able to pivot, or any other way to where it is workable? This will be something I battle quarterly, so having a better solution than deleting stuff out to be continuous would be much appreciated. If yall need visual aid, let me know, I would have to scrub some stuff.
Thanks in advance