Skip to Content
0
Former Member
Dec 04, 2006 at 01:14 PM

Merging ALV column Cells Vertically.

77 Views

Hi all,

I have an ALV grid with 14 columns. I wish to merge cells vertically in columns 1 ( lot ) and column 2 ( sequence ) where the data is the same. I have managed to do this on column 1 successfully but now wish to merge column 2 cells that have common values in column 1. See before ( Raw format ) and after ( merged format ) examples below.

To edit correctly, I have used astericks to represent spaces ( as a result of merging cells ) and hyphens to prevent the editor compressing the spaces in the illustration !

Many thanks, in advance, for your time.

Nigel.

Raw format

Lot----


Sequence----


Payment -Posting Date -Etc

PA-000001----


1----

-


£100

PA-000001----


2----

-


£50

PA-000001----


3----

-


£2

PA-000002----


2----

-


£29

PA-000003----


2----

-


£20

PA-000003----


4----

-


£10

PA-000003----


4----

-


£33

PA-000005----


1----

-


£47

PA-000005----


1----

-


£100

PA-000005----


1----

-


£12

PA-000005----


3----

-


£116

Merged format.

Lot----


Sequence-- Payment -Posting Date----


PA-000001----


1----

-


£100

*************----


2----

-


£50

*************----


3----

-


£2

PA-000002----


2----

-


£29

PA-000003----


2----

-


£20

*************----


4----

-


£10

*************----


*----

-


£33

PA-000005----


1----

-


£47

*************----


*----

-


£100

*************----


*----

-


£12

*************----


3----

-


£116