Hi All,
I need to transpose the information in this table as per attached example.
Unfortunately, my attempts keep failing!
Thank you in advance.
| | | INPUT | | | | | | | | | | | | OUTPUT | | | | | |
| | | | | | | | | | | | | | | | | | | | | |
| Order | Code | ID | Name | Country | | | Order | AG | Name AG | EN | Name EN | RE | Name RE | RG | Name RG | WE | Name WE | ZB | Name ZB | Country |
| 143450666 | AG | 1448828 | Name1 | GB | | | 143450666 | 1448828 | Name1 | 1448828 | Name1 | 1453271 | Name1.2 | 1448828 | Name1 | 84020623 | Name1 | 84020623 | Name1 | GB |
| 143450666 | EN | 1448828 | Name1 | GB | | | 143451061 | 1432111 | Name2 | 1432111 | Name2 | 1432111 | Name2 | 1432111 | Name2 | 84003347 | Name2 | 84003347 | Name2 | DE |
| 143450666 | RE | 1453271 | Name1.2 | GB | | | 143470287 | 1468689 | Name3 | 1468689 | Name3 | 1468689 | Name3 | 1468689 | Name3 | 84075788 | Name3 | 84075788 | Name3 | FR |
| 143450666 | RG | 1448828 | Name1 | GB | | | | | | | | | | | | | | | | |
| 143450666 | WE | 84020623 | Name1 | GB | | | | | | | | | | | | | | | | |
| 143450666 | ZB | 84020623 | Name1 | GB | | | | | | | | | | | | | | | | |
| 143451061 | AG | 1432111 | Name2 | DE | | | | | | | | | | | | | | | | |
| 143451061 | EN | 1432111 | Name2 | DE | | | | | | | | | | | | | | | | |
| 143451061 | RE | 1432111 | Name2 | DE | | | | | | | | | | | | | | | | |
| 143451061 | RG | 1432111 | Name2 | DE | | | | | | | | | | | | | | | | |
| 143451061 | WE | 84003347 | Name2 | DE | | | | | | | | | | | | | | | | |
| 143451061 | ZB | 84003347 | Name2 | DE | | | | | | | | | | | | | | | | |
| 143470287 | AG | 1468689 | Name3 | FR | | | | | | | | | | | | | | | | |
| 143470287 | EN | 1468689 | Name3 | FR | | | | | | | | | | | | | | | | |
| 143470287 | RE | 1468689 | Name3 | FR | | | | | | | | | | | | | | | | |
| 143470287 | RG | 1468689 | Name3 | FR | | | | | | | | | | | | | | | | |
| 143470287 | WE | 84075788 | Name3 | FR | | | | | | | | | | | | | | | | |
| 143470287 | ZB | 84075788 | Name3 | FR | | | | | | | | | | | | | | | | |
