Grouping values from consecutive records into 1 record

7 posts / 0 new
Last post
bluecox
Offline
Joined: 10/17/2018 - 05:33
Grouping values from consecutive records into 1 record

Hello all,
Below is one of the table that i use in my analysis.The table contain some unique reference number in first column and some additional reference data in column 2.
 
What I am trying to achieve is to make sure that for every unique reference number (URN) in column 1 that occurs multiple times (more than one) the values from column 2 can be displayed in the same record. In the above example I would like see a new table in which UNR: 29746 will be located in first column and in the next column of the same record it should be displayed: 0,333. 0 and 333 can be displayed in 2 separate columns.
or 
 
I tried using loop going through the recordset of records in IDEA to identify multiple URN and then copy associated values from the adjacent columne but it doesnt work correctly. 
Any help is much apprieciated.
 
 
 
 
 

bluecox
Offline
Joined: 10/17/2018 - 05:33

b

Images: 
bluecox
Offline
Joined: 10/17/2018 - 05:33

Does anyone have an idea how to convert the above table?

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

How do you want it converted?

bluecox
Offline
Joined: 10/17/2018 - 05:33

The below would be the prefered way of grouping the results:
 
 

Images: 
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

So do you want one field with all the items or one field per item?

bluecox
Offline
Joined: 10/17/2018 - 05:33

Either option is fine.However it think one field is a cleaner option.Thank you.