I have a program that produces a spreadsheet that eventually shrinks to zero. IT repeats the zero until a gap and the repeats with the next set of information. The data sometimes uses 120/124 cells and sometimes uses 3/124 cells. I've abbreviated for illustration purposes. Is there a formula or set of formulas that I can utilize to select and copy the needed data to something that's more workable? The dots illustrate moving to the next cell.
Row1..Unique Title
Row2..some description
Row3..Good stuff
Row4..Good stuff
Row5..6..10..2
Row6..5..9..1
Row7..2..8..0
Row8..2..5..0
Row9..1..3..0
Row10..0.1..0..
Row11..0..0..0
Row12..0..0..0
Row13..0..0..0 (This repeats for a long time until...124..0..0..0 or so then there is a break and new data that follows this pattern exists. If I add columns B,C,and D I only want to discard when the total is 0. So I want Rows 1-10 but not 11-124. There will then be unique title1 and a variable amount of rows with good data followed by the remainder of the 124 rows of all zeros. I know there is a way to get this information without having to manually select and delete the rows with all zero's. This is a hurdle I've not been able to get over for a while. Any suggestions are welcome.
Bookmarks