Maybe my search words are lacking what they need for me to find the answer, so I need help.
I have a table like this, where you can see Mod "a" was duplicated on 2 rows.
I was trying to write the code to where if it was matching in column A, pasteall skip blanks, but It's not working for me.
Any help or advise?
<tbody>
</tbody>
The output I am trying to get to.
<tbody>
</tbody>
I have a table like this, where you can see Mod "a" was duplicated on 2 rows.
I was trying to write the code to where if it was matching in column A, pasteall skip blanks, but It's not working for me.
Any help or advise?
Mod | 1001 | 1002 | 1003 | 1004 |
A | X | |||
A | X | |||
A | X | |||
B | X | |||
B | X | |||
C | X | |||
D | X | |||
D | X | |||
D | X |
<tbody>
</tbody>
The output I am trying to get to.
Mod | 1001 | 1002 | 1003 | 1004 |
A | X | x | x | |
B | X | x | ||
C | X | |||
D | X | x | x |
<tbody>
</tbody>
Last edited: