Hi, Can someone tell me if there is a function in Phoenix which transposes/rearrange the individual plasma concentration-time data from row-wise to column-wise? For example.. What I have is a spreasheet containing subject, period, treatment, sequence, n1.. n-1 from a 2-way crossover study.. The data is presented in rows per subject, for example… Subject Period Treatment Sequence n1..n3 1, 1, 1, 1, 0.0, 1.2, 0.4 1, 2, 2, 2, 0.0, 1.4, 0,.6 Is there is function in Phoenix Winnonlin to conver the data into a presentation by column? Subject Period Treatment Sequence n 1, 1, 1, 1, 0.0 1, 1, 1, 1, 1.2 1, 1, 1, 1, 3.4 1, 2, 2, 2, 0.0 1, 2, 2, 2, 1.4 1, 2, 2, 2, 0.6 Thanks
John, I’m not sure I follow the data formats you are starting from and want to go to but Pivot or Stacker (both in the Data folder) are the options I would suggest, here is an example using Stacker; Source data looks like; Settings to convert it are;
which gives
Thank you! That’s what I am looking for. The reason is that the data I received from the lab is always arranged by rows with row #1 = timepoint and the subsquent rows are subject data.