Ask Your Question

custom merging on range of numbers in rows

asked 2018-12-22 05:38:53 +0200

clos911 gravatar image

updated 2018-12-22 06:01:56 +0200

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:




instead of my current:





which take up a lot of space .

any help is appreciated. thank you.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-22 07:20:35 +0200

pierre-yves samyn gravatar image


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

You could use DataGroup and OutlineGroup: 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).


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-22 05:38:53 +0200

Seen: 27 times

Last updated: Dec 22 '18