Lets say I have the following data:

read.table(text="X1 X2 X3 X4 X5 A B C 
1  2  3  4  5  1 1 0
A  B  C  D  E  0 0 1 ", sep="", header=TRUE)

or

X1 X2 X3 X4 X5 A B C 
1  2  3  4  5  1 1 0
A  B  C  D  E  0 0 1 

And I want to create:

NAME Values X1 X2 X3 X4 X5 
A    1      1  2  3  4  5  
A    0      A  B  C  D  E
B    1      1  2  3  4  5  
B    0      A  B  C  D  E
C    0      1  2  3  4  5  
C    1      A  B  C  D  E

What would be a good way to do this in a very big dataset? (200k rows, 2000 columns, 1944 columns to be “transposed”)