i'm dealing with columns A and F. I need to add letter A to end all values in Columns A if Column F has Level or Roof in columns F.
Data before modified
Column A Column F
<colgroup><col><col></colgroup><tbody>
</tbody>Column A Column F
<colgroup><col><col></colgroup><tbody>
</tbody>
Data before modified
Column A Column F
P1.00 | LEVEL |
P1.09 | LEVEL |
P1.10 | LEVEL |
M1.11 | ROOF PLAN |
M1.12 | ROOF PLAN LOW |
P2.00 | |
P4.00 | |
P5.00 | |
P6.00 | |
Data after modified |
<colgroup><col><col></colgroup><tbody>
</tbody>
P1.00A | LEVEL |
P1.09A | LEVEL |
P1.10A | LEVEL |
M1.11A | ROOF PLAN |
M1.12A | ROOF PLAN LOW |
P2.00 | |
P4.00 | |
P5.00 | |
P6.00 |
<colgroup><col><col></colgroup><tbody>
</tbody>