A file CSV data was opened in Calc of my investment holdings. For each row of data, there was a duplicate row because the full name of the stock is listed on a hidden second row. Is there a way to hide every other row in a range of rows without selecting each other one manually?
Illustration:
Thanks.
Ask that holding to fix their csv.
You can add a column and put this formula:
=MOD(ROW(),2)
which will return 0 or 1. You can then use a filter to only show the rows you want, by selecting 1 or 0.
Brilliant! Thank you.
More versatile that using HIDE.
I used the Standard Filter to select the rows I did not want and deleted those rows. I turned off the Standard Filter then deleted the added column with the MOD(Row(),2) function. It worked great!
/Stevieblueboat
Both, filtering and hiding has no effect on calculations. If you delete the rows of a filtered range, you remove only the visible rows and get correct data. The problem is that your bloody holding delivers wrong data.
Or just, type 1 and 0 in a column next to the data, and double-click on the fill square while holding Ctrl.
Perhaps they do on purpose… who knows. 
And, yes I have found that when you Hide or Filter the rows not wanted, you’re able to copy what’s visible and paste it someplace else so that you can manage it. Thanks.
Yes… that works too!
It’s a two step process:
Thanks.
With the function “=SUBTOTAL()” you are able to switch in calculation between cells that are faded out or faded in.