Converting Rows into colums(Urgent)

Hi All,

I have problem to convert data from Rows to colums but i do not want to use Transpose option because i need to do it one by one. For example:

A 1 2 3 4
B 5 6 7 8
C 9 10 11 12

I need to convert it into columns in one go..like following:
A 1
A 2
A 3
A 4
B 5
B 6
B 7
B 8
C 9
C 10
C 11
C 12
Any one can help me please in this issue...if you can guide me which formula should i use...

BR// Saif