Discussion Locked

Convert database table

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.