Combining rows with serial data

jsolo01

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

jthi

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