Dynamic Merging of cells

[SilverBullet]

Hi everyone,

I have a challenge that I'd like some help with:

I have a report right now that looks something like the following

SALES_NUM  CUSTOMER  ITEMS SOME_ORDER_INFO COMMENTS
12345678    Buyer1   Item A  ~~~~~~~~~~~~ BIG COMMENT
12345678             Item B
12345678             Item C
12345678             Item D
12345678             Item E

44444444   Buyer2   Item A   ~~~~~~~~~~~~~  COMMENT

For the purposes of this report, the users don't want to see repeating information - except for the sales numbers.

The problem is that "BIG COMMENT" is up to 2000 characters in length. Right now it's word wrapped and enlarges the first row of every order ... but this isn't ideal. If I could, I'd like to merge the cells on the right, so that I don't waste paper enlarging the first row, and then subsequent rows are empty.

New report:

SALES_NUM  CUSTOMER  ITEMS SOME_ORDER_INFO COMMENTS
12345678    Buyer1   Item A  ~~~~~~~~~~~~ BIG COMMENT
12345678             Item B                       IN
12345678             Item C                       ALL
12345678             Item D                       THESE
12345678             Item E                       CELLS

44444444   Buyer2   Item A   ~~~~~~~~~~~~~  COMMENT

Sort of idea.

The thing that might make this much easier, is the fact that there is an entirely empty (null) row between orders. The first row is guaranteed to have information if the order exists, and the first column is fully populated except for the empty fields between orders

Any ideas would be appreciated.