topic Re: Combining rows with serial data in Discussions

Combining rows with serial data

jsolo01 — Sat, 10 Jun 2023 23:58:28 GMT

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 — Fri, 16 Dec 2022 16:25:15 GMT

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

jsolo01 — Fri, 16 Dec 2022 20:50:52 GMT

that works! Thanks

fja — Sun, 18 Dec 2022 22:27:56 GMT

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