Excel Converting rows into each individual reports

[Freddy Fung]

Hi everyone,
How do I write a macro or convert each row in a table into each individual reports.
Eg.
Name A B C D E F
John. 1 2 3 4 5 6
Jane 5 6 7 8 9 0

Name John
A. 1 D. 4
B. 2. E. 5
C 3 F. 6

Name Jane
A. 5 D. 8
B. 6 E. 9
C 7 F. 0

Thank you very much
Freddy Fung