Trying to figure out a way to do this in Access without going to Excel and back.
I have a table myTable which looks like this:
and want it to look like this:
fld1 fld2 fld3 fld4 fld5
bob blue green white yellow
mike pink purple red