Need Help creating formula to rid a data set of blank rows based of 2 result columns

So I am working off of an existing template that someone else created and things were working OK until I got to my results. I am attaching a sample file stripped of other sheets except for the one I am working with. So her is a summary. To the left of the Blue Line is data that comes from other sheets of with all results, there are blank rows because some time points were not tested. So since this is an exact transfer of all data from other sheets there may or may not be blanks. To the right of the blue line I am trying to remove all the blank rows and put all data together to be used on another sheet for graphing and analyzing. So I was able to use the existing index/match formula with arrays to get rid of all blank rows for the first 5 columns, but when it comes to the results I get a mismatch and it doesn't line up correctly. The formula just removes blanks but doesn't take into account to keep the data in the same row as it's corresponding time point. And I have 2 columns of results and sometimes there may only be one result on either column or both. I need help in creating a formula to remove blanks yet keep the time point result correlations. Can someone please help me!!!

Isara1

Try this ARRAY formula.
IN M2, then drag across

Please Login or Register  to view this content.

It's not working, I'm still getting the same misalignment of data. Take a look at the attached files. If you see the Original Data file at time 0 I only have 1 result for Result 1 and at time 20 I only have 1 result again but for result 2 on the other column. If you look at the misalignment file which is the other side at time 0 I am seeing both values on one row and that is not right. So yes, I want to delete blanks but not where they should actually be a blank.

OK Sorry I thought the array name needed to change for each column so that was the issue. When I kept it the same it all worked well. Thank you soo much.


Isara1

Thanks for feed back. Pl mark the thread solved.