Link to home
Start Free TrialLog in
Avatar of TOM BURKHARDT
TOM BURKHARDTFlag for Canada

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      
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

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
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TOM BURKHARDT

ASKER

wow. thanks, Capricorn1. I didn't realise until I started playing in Excel that it wasn't just a simple transposition.
sorry, Sharath_123, I didn't see your question until I'd already accepted Capricorn's response .