Custom merging on range of numbers in rows

[clos911]

Hello, I have a lot of rows and I am trying to save space on my spreadsheet…
the first column in my spreadsheet is the item number, the second column is description, third column is details.
Every 20 items are the same and have identical description and details i.e. Item numbers 1 thru 20 have the same description/details, items 21 thru 40 are a different item but share same description and details and so on…

instead of having individual rows for each item, I’d like to merge them in groups of 20 to display like:

1-20

21-40

41-60…

instead of my current:

1

2

3

4…

which take up a lot of space .

any help is appreciated. thank you.

[PYS]

Hi

I assume that additional columns, not described, contain different data per row (otherwise, the simplest solution would be to remove duplicates…).

You could use Data▸Group and Outline▸Group: selection of lines to group then F12

See this example.

If there is an intermediate line containing one or more formulas (see subtotals), the creation of the group could even be automatic (see AutoOutline).

Regards