Hallo,
in our company we use Word merge for some Agreements. No problem to specify commands IF for example:
{ IF { MERGEFIELD name }<>"" { MERGEFIELD birh no } "................" } etc.
but this is only to specify only for column record,,,,

Excel:
1st row.... LV = 1, name = Mr. Black
2nd row... LV = 1, name = Mr. Brown
3rd row... LV = 1, name = Mrs. Brown
4th row... LV = 2, name = Mr. Blue
5th row... LV = 3, name = Mrs. Blue
6th row... LV = 3, name = Mr. White
..
..
etc.

Word: (merge to Excel)
1st Agreement for LV = 1.... 3 people on one page (Mr. Black, Mr. Brown, Mrs. Brown)2nd Agreement for LV = 2.... 1 people on one page (Mr. Blue)
3rd Agreement for LV = 3.... 2 people on one page (Mrs. Blue, Mr. White)..
..
etc.

Many thanks.

Jerry (CZ)