Hello All,
kindly help me to get below mentioned output.
INput:
| LOB | ID | AM | AWM Ops | IPB | US PB | US WM | WM (Detail Deck Only) | Chase Auto | BCC | Business Banking | Card Services | CCB Ops | Consumer Banking | Data & Analytics | Digital | Home Lending | Marketing | CCB Finance | CCB HR | CCB Strategy | CCB Technology |
| US WM | 125533 | NA | NA | NA | NA | US WM | NA | | | | | | | | | | | | | | |
| CREDIT CARD | 125533 | | | | | | | NA | NA | NA | CREDIT CARD | NA | NA | NA | NA | NA | NA | | | | |
Expected Output:
| LOB | ID | AM | AWM Ops | IPB | US PB | US WM | WM (Detail Deck Only) | Chase Auto | BCC | Business Banking | Card Services | CCB Ops | Consumer Banking | Data & Analytics | Digital | Home Lending | Marketing | CCB Finance | CCB HR | CCB Strategy | CCB Technology |
| US WM | 125533 | NA | NA | NA | NA | US WM | NA | NA | NA | NA | CREDIT CARD | NA | NA | NA | NA | NA | NA | | | | |
| CREDIT CARD | 125533 | NA | NA | NA | NA | US WM | NA | NA | NA | NA | CREDIT CARD | NA | NA | NA | NA | NA | NA | | | | |
Thanks & Regards,
Niru
