PC Review


Reply
Thread Tools Rate Thread

Conversion of Rows into Colums

 
 
BusyProfessorFromBremen
Guest
Posts: n/a
 
      22nd May 2009
Hi @ all,

I am experiencing a problem by working onMS Access. I have got a huge table
containing a lot of information (both columns and rows). There are rows
listed with repeating values containing the same ID Number. To this ID number
there are at maximun 3 other values related.
Thus I would like to put these 3 values into one row, that one row belongs
to one particular IDnumber.

EXAMPLE:

State of the art

ID VALUEs

123 5
123 6
123 7

The result should be:

ID Value 1 Value 2 Value 3
123 5 6 7

It would be very kind if anybody has got a clou how to handle this affair.

Kind regards and thanks in advance

malte
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion of Rows into Colums BusyProfessorFromBremen Microsoft Access VBA Modules 10 28th May 2009 04:32 PM
Colums to rows Gary Hull Microsoft Access Form Coding 1 7th Apr 2008 03:30 PM
rows to columns and colums to rows Bravo Microsoft Excel Programming 5 10th Oct 2007 06:20 PM
How do change rows to colums AND columns to rows =?Utf-8?B?Q29sbGVlbiBB?= Microsoft Excel Misc 7 30th Dec 2005 12:40 AM
Print few rows with many colums so that rows wrap on printed pages =?Utf-8?B?dXNmZ3JhZHN0dWRlbnQzMQ==?= Microsoft Excel Misc 1 20th Oct 2005 02:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:32 AM.