I have a sheet that has two separate tables. One set has energy and the other regulatory. Based on the titles of the table I need to separate them. So from A1 to XX that is Energy. From where the title regulatory starts and on to the end that will be regulatory. So not only do I first separate the tables at first I will have a new field called type and that will be used to show which set of data is regulatory and which is energy. Then I can join it back together.
I cannot figure out how to accomplish that.
I'm not completely sure I understand the structure of your data. Is there a possibility you could share a sample of this data? If confidential, then can you mockup some data that looks similar?