My problem is as such:
I have a sheet of data that is very frequently updated, but needs an easy overview for some other code to work. Basically, this data-sheet needs to be able to insert a blank row every time a specific condition is met. Actually, it's easier to show:
Input
<TBODY>
</TBODY>
Desired output
<TBODY>
</TBODY>
Basically, every time a cell in column A isn't blank, there should be a blank row - without losing the data from the other two columns.
I already have a simple array running that sorts everything by colour, as well as one that removes any duplicate colours. So, I just need to figure out a way that I can (non-manually) insert this blank row in my sheet. Please note that this data is not static. So I may one day have one Blue, the next day seven, and then four the day after...
I have a sheet of data that is very frequently updated, but needs an easy overview for some other code to work. Basically, this data-sheet needs to be able to insert a blank row every time a specific condition is met. Actually, it's easier to show:
Input
Blue | Sample 1 | Bat |
Yellow | Sample 2 | Cat |
Sample 3 | Rat | |
Red | Sample 3 | Hat |
<TBODY>
</TBODY>
Desired output
Blue | ||
Sample 1 | Bat | |
Yellow | ||
Sample 2 | Cat | |
Sample 3 | Rat | |
Red | ||
Sample 3 | Hat |
<TBODY>
</TBODY>
Basically, every time a cell in column A isn't blank, there should be a blank row - without losing the data from the other two columns.
I already have a simple array running that sorts everything by colour, as well as one that removes any duplicate colours. So, I just need to figure out a way that I can (non-manually) insert this blank row in my sheet. Please note that this data is not static. So I may one day have one Blue, the next day seven, and then four the day after...