This is a sample of the data I have
I would like to have my data like this - Image titled target file
Please let me know how this can be done with or without macros.
Source data
Target data
I would like to have my data like this - Image titled target file
Please let me know how this can be done with or without macros.
Source data
Staffname | Empname | EmpID | Project1 | Domain | Subdomain | Project2 | Domain | Subdomain |
A | AX | 1 | WER | WERD | WERS | PQR | PQRS | PQRA |
B | BA | 2 | VAR | VARD | VARS | EWR | EWRS | EWRA |
Target data
Staffname | Empname | EmpID | Projects | Domain | Subdomain |
A | AX | 1 | WER | WERD | WERS |
A | AX | 1 | PQR | PQRS | PQRA |
B | BA | 2 | VAR | VARD | VARS |
B | BA | 2 | EWR | EWRS | EWRA |