Can you please help me in writing the syntax for the below mentioned table.
Input :
| ID | Col A | Col B | Col C | Col D | Col E | Col F |
| 1111 | aaaa | bbbb | cccc | dddd | eeee | ffff |
| 2222 | bbbb | cccc | dddd | eeee | ffff | aaaa |
| 3333 | cccc | dddd | eeee | ffff | aaaa | bbbb |
| 4444 | dddd | eeee | ffff | aaaa | bbbb | cccc |
| 5555 | eeee | ffff | aaaa | bbbb | cccc | dddd |
| 6666 | ffff | aaaa | bbbb | cccc | dddd | eeee |
| 7777 | cccc | dddd | eeee | ffff | aaaa | bbbb |
| 8888 | dddd | eeee | ffff | aaaa | bbbb | cccc |
| 9999 | ffff | aaaa | bbbb | cccc | dddd | eeee |
Required Output :
| ID | Col Name | Col Value |
| 1111 | Col A | aaaa |
| 1111 | Col B | bbbb |
| 1111 | Col C | cccc |
| 1111 | Col D | dddd |
| 1111 | Col E | eeee |
| 1111 | Col F | ffff |
| 2222 | Col A | bbbb |
| 2222 | Col B | cccc |
| 2222 | Col C | dddd |
| 2222 | Col D | eeee |
| 2222 | Col E | ffff |
| 2222 | Col F | aaaa |
| 3333 | Col A | cccc |
| 3333 | Col B | dddd |
| 3333 | Col C | eeee |
| 3333 | Col D | ffff |
| 3333 | Col E | aaaa |
| 3333 | Col F | bbbb |
And so on for the 4444, 5555, 6666, 7777, 8888, 9999
Thanks,
Srikanth B
