This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have an excel which has data generated every month as shown below,
>40 Total encounters
>50 Total encounters
As you can see, there 2 tables within the same sheet 'Central' and 'Central MAT' and the corresponding data follows. I would like to separate these data, where Central table will have 2 lines(Data between Central header and >40 Encounters) and Central MAT with 2 lines(Data between Central MAT header and >50 Encounters). This data is dynamic monthly and hence the process of extracting the data between the tables needs to be dynamic as well.