Dear Sir/Madam,
Would appreciate if you could advise which function or steps to use to convert a horizontal table to vertical table, i.e
From horizontal table
A B C D E
1 2 3 4 5
to the following vertical table
A 1
B 2
C 3