I have a data table as shown below:
What I need to do is take all the numbers and but them in one column and all the letter in a adjacent column. As shown below:
Any help would be appreciated!
1 | a | 6 | f | 11 | k |
2 | b | 7 | g | 12 | l |
3 | c | 8 | h | 13 | m |
4 | d | 9 | i | 14 | n |
5 | e | 10 | j | 15 | o |
What I need to do is take all the numbers and but them in one column and all the letter in a adjacent column. As shown below:
1 | a |
2 | b |
3 | c |
4 | d |
5 | e |
... | ... |
Any help would be appreciated!