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