Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transform from columns to rows?

Status
Not open for further replies.
owrsome

owrsome

Technical User
Joined
Jan 13, 2003
Messages
18
Location
US
I have data in two columns

Company1 Apples
Company1 Pears
Company1 Cherries
Company2 Cherries
Company3 Apples

and want to tranform to four columns

Company1 Apples Pears Cherries
Company2 Cherries
Company3 Apples

I'd be grateful for advice.
 
Sort by date Sort by votes
check out faq701-3499

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Question Question
Why does what appears to be a simple append query is pasting 5 duplicate rows?
Replies
9
Views
316
TheresAlwaysAWay
TheresAlwaysAWay
BugZap13
  • Locked
  • Question Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
872
mikrom
mikrom
breezett93
  • Locked
  • Question Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
781
breezett93
breezett93
serino
  • Locked
  • Question Question
Delete From Table
Replies
1
Views
934
Andrzejek
Andrzejek
C
  • Locked
  • Question Question
Query expression negative to a 0
Replies
6
Views
749
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top