TOM BURKHARDT
asked on
how do I transpose these two fields to rows?
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:
fld1 fld2
bob blue
bob green
bob white
bob yellow
mike pink
mike purple
mike red
and want it to look like this:
fld1 fld2 fld3 fld4 fld5
bob blue green white yellow
mike pink purple red
I have a table myTable which looks like this:
fld1 fld2
bob blue
bob green
bob white
bob yellow
mike pink
mike purple
mike red
and want it to look like this:
fld1 fld2 fld3 fld4 fld5
bob blue green white yellow
mike pink purple red
you will need VBA codes to do this. Is this an option?
The maximum no. of colors for any user is alway 4?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
wow. thanks, Capricorn1. I didn't realise until I started playing in Excel that it wasn't just a simple transposition.
ASKER
sorry, Sharath_123, I didn't see your question until I'd already accepted Capricorn's response .