Can anyone advise how could get the following result in MSAccess.
Original: Name A B Peter 10 20 Mary 50 40
To this below : Peter A 10 Peter B 20 Mary A 50 Mary B 40
Would appreciate some help, thnak you
Rgds.
