Hello to all,

I have the Range B:F for "Values MJ" and columns G:K with "Values RT". In column A there is a letter for each row

but some letters could appear more than once and I want to have only unique letters in column A and merged the

Range B:F for "Values MJ" and columns G:K with "Values RT" in the same row for those repeated letters.

Original data:

[TABLE="class: grid, width: 1040"]

[tr]

[TD="width: 80"][/TD]

[TD="width: 80"]A[/TD]

[TD="width: 80"]B[/TD]

[TD="width: 80"]C[/TD]

[TD="width: 80"]D[/TD]

[TD="width: 80"]E[/TD]

[TD="width: 80"]F[/TD]

[TD="width: 80"]G[/TD]

[TD="width: 80"]H[/TD]

[TD="width: 80"]I[/TD]

[TD="width: 80"]J[/TD]

[TD="width: 80"]K[/TD]

[TD="width: 80"]L[/TD]

[/tr]

[tr]

[TD="align: right"]1[/TD]

[td][/td]

[TD="colspan: 5"]Values MJ[/TD]

[TD="colspan: 5"]Values RT[/TD]

[td]

Values JHK

[/td]

[/tr]

[tr]

[TD="align: right"]2[/TD]

[TD="width: 80"]Letter[/TD]

[TD="width: 80"]G

[/TD]

[TD="width: 80"]H[/TD]

[TD="width: 80"]T[/TD]

[TD="width: 80"]W[/TD]

[TD="width: 80"]S[/TD]

[TD="width: 80"]G

[/TD]

[TD="width: 80"]H[/TD]

[TD="width: 80"]T[/TD]

[TD="width: 80"]W[/TD]

[TD="width: 80"]S[/TD]

[TD="width: 80"]U[/TD]

[/tr]

[tr]

[TD="align: right"]3[/TD]

[td]

B

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

4

[/td]

[td]

2

[/td]

[td]

0

[/td]

[td]

0

[/td]

[td]

6

[/td]

[td]

0

[/td]

[/tr]

[tr]

[TD="align: right"]4[/TD]

[td]

C

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

1

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

1

[/td]

[td]

5

[/td]

[td]

1

[/td]

[/tr]

[tr]

[TD="align: right"]5[/TD]

[td]

A

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

2

[/td]

[td]

0

[/td]

[td]

4

[/td]

[td]

2

[/td]

[td]

8

[/td]

[td]

2

[/td]

[/tr]

[tr]

[TD="align: right"]6[/TD]

[td]

R

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

7

[/td]

[td]

22

[/td]

[td]

8

[/td]

[td]

4

[/td]

[td]

41

[/td]

[td]

1

[/td]

[/tr]

[tr]

[TD="align: right"]7[/TD]

[td]

C

[/td]

[td]

0

[/td]

[td]

3

[/td]

[td]

10

[/td]

[td]

5

[/td]

[td]

18

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[TD="align: right"]8[/TD]

[td]

T

[/td]

[td]

1

[/td]

[td]

4

[/td]

[td]

12

[/td]

[td]

6

[/td]

[td]

23

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[TD="align: right"]9[/TD]

[td]

A

[/td]

[td]

7

[/td]

[td]

2

[/td]

[td]

3

[/td]

[td]

1

[/td]

[td]

11

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[/TABLE]

If a letter only have values in range B:F print "Missing" in range G:K for the same row.

If a letter only have values in range G:K print "Missing" in range B:F for the same row.

I'd like to delete the row of the letter if the repeated letter has values in B:F, since letters for ranges B:F

always appear after the letters that have values in range G:K and since I'd like the output in same sheet.

Output desired:

[TABLE="class: grid, width: 1040"]

[tr]

[TD="width: 80"][/TD]

[TD="width: 80"]A[/TD]

[TD="width: 80"]B[/TD]

[TD="width: 80"]C[/TD]

[TD="width: 80"]D[/TD]

[TD="width: 80"]E[/TD]

[TD="width: 80"]F[/TD]

[TD="width: 80"]G[/TD]

[TD="width: 80"]H[/TD]

[TD="width: 80"]I[/TD]

[TD="width: 80"]J[/TD]

[TD="width: 80"]K[/TD]

[TD="width: 80"]L[/TD]

[/tr]

[tr]

[TD="align: right"]1[/TD]

[TD="width: 80"]Letter[/TD]

[TD="colspan: 5"]Values MJ[/TD]

[TD="colspan: 5"]Values RT[/TD]

[td]

Values JHK

[/td]

[/tr]

[tr]

[TD="align: right"]2[/TD]

[TD="width: 80"]G

[/TD]

[TD="width: 80"]H[/TD]

[TD="width: 80"]T[/TD]

[TD="width: 80"]W[/TD]

[TD="width: 80"]S[/TD]

[TD="width: 80"]G

[/TD]

[TD="width: 80"]H[/TD]

[TD="width: 80"]T[/TD]

[TD="width: 80"]W[/TD]

[TD="width: 80"]S[/TD]

[TD="width: 80"]U[/TD]

[/tr]

[tr]

[TD="align: right"]3[/TD]

[td]

B

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

4

[/td]

[td]

2

[/td]

[td]

0

[/td]

[td]

0

[/td]

[td]

6

[/td]

[td]

0

[/td]

[/tr]

[tr]

[TD="align: right"]4[/TD]

[td]

C

[/td]

[td]

0

[/td]

[td]

3

[/td]

[td]

10

[/td]

[td]

5

[/td]

[td]

18

[/td]

[td]

1

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

1

[/td]

[td]

5

[/td]

[td]

1

[/td]

[/tr]

[tr]

[TD="align: right"]5[/TD]

[td]

A

[/td]

[td]

7

[/td]

[td]

2

[/td]

[td]

3

[/td]

[td]

1

[/td]

[td]

11

[/td]

[td]

2

[/td]

[td]

0

[/td]

[td]

4

[/td]

[td]

2

[/td]

[td]

8

[/td]

[td]

2

[/td]

[/tr]

[tr]

[TD="align: right"]6[/TD]

[td]

R

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

7

[/td]

[td]

22

[/td]

[td]

8

[/td]

[td]

4

[/td]

[td]

41

[/td]

[td]

1

[/td]

[/tr]

[tr]

[TD="align: right"]7[/TD]

[td]

T

[/td]

[td]

1

[/td]

[td]

4

[/td]

[td]

12

[/td]

[td]

6

[/td]

[td]

23

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td]

Missing

[/td]

[td][/td]

[/tr]

[/TABLE]

I hope make sense.

Thanks in advance.