By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Vertical Table to Horizontal Query

P: 1
Need to convert the following
Data is in a table

Name Age
John 20
Alan 30
Joan 25
David 35
John 25
Alan 55
Joan 40

To the following

Name Age Age
John 20 25
Alan 30 55
Joan 25 40
David 35

Thank You
Aug 20 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,660
This isn't something Access (or any RDBMS of course) does for you naturally. Check out Combining Rows-Opposite of Union for a coded (VBA) solution though.
Aug 20 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.