582643_en-US

liliconcom

Combining rows with serial data

Hi - there are a few posts on this but they dont address this specific issue

i need to get from example 1 to example 2.  combine rows by ID # into one row with data aligned sequentially.  Thanks

example 1

id    visit#.   PGA 

1      1          5

1      2          3 

2      3        12

2      5         7

2      6         4

 

example 2

id.   visit#    PGA.   visit#.   PGA.    visit#.  PGA#

1.      1         5          2           3     

2.       3        12        5           7           6         4

Advanced Statistical ModelingContent OrganizationRe: Combining rows with serial data

---

@jsolo01 wrote:

that works!  Thanks

---

Lovely! Could you mark @jthi 's answer as a solution then? ... and generously spare it a kudo/like ...  just to keep people motivated.  

Re: Combining rows with serial data

that works!  Thanks

Re: Combining rows with serial data

One option is to create new grouping column with something like

Col Cumulative Sum(1, :id)

 

after this you can split the table

and end up with

then you can move the columns around