As shown in below screen shot I have three revisions. Some sheets has all three revisions but has either one or two only. In the last column (TERMED AS FINAL in BELOW ) i need to show the latest revision.
<tbody>
</tbody>
SHEET | REV. 01 | REV. 02 | REV. 03 | FINAL |
P029-DDD-STR-0001 | A | B | ||
P029-DDD-STR-0002 | A | B | C | |
P029-DDD-STR-0003 | A | |||
P029-DDD-STR-0004 | 1 | B | ||
P029-DDD-STR-0003 | 1 | C |
<tbody>
</tbody>