Combining rows with serial data

[#1]

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

[#2 · Accepted solution]

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

[#3]

that works!  Thanks

[#4]

---

@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. :)